Recent Changes - Search:

ProReports

edit SideBar

Respect my work!
If you are using commercially ProReports pay donate:

or

      PayPal.Me

or

        BTC: 

1MTFbBSKrocPK7G6GKfG8RoTw5N57WnnNa

If you have paid donate send me e-mail with Your data or transaction number to receive an access code to articles with limited access.

ChangeLog for ProReports

Version 3.1.29.h.r61-utf8 (2020-10-04)

  • added function autocomplete when coding reports (type part of a word and press Ctrl-Space)
  • due to the fact that from next year Adobe Flash Player will be disabled in web browsers, I have made a review of graphic libraries available in ProReports. The current version includes:
Hint!

If you want to install another graphic library for javascript you must copy all files to directory <proreports_dir>/webapps-plus/rep/libgraph/<name_of_library>/<name_of_library>-<version>

Version 3.1.29.h.r60-utf8 (2020-02-10, rev. 2020-08-07)

  • the method of presenting the list of fields has been changed.
  • the method of presenting the list of layers has been changed.
  • fixed several bugs.

(rev. 2020-08-70)

  • autoscaling window size in dashboard to width and height of displayed screen (when in field: W or H is setting max value: 9999).
  • new parametr in script rep_form_gen.php - nobtn=T (buttons not displayed in form) - this give you chance to use defined forms in dashboard window without standard buttons (you must define you own buttons).

Version 3.1.29.h.r59-utf8 (2020-01-18)

  • added in simple report list field based on MainSQL (in section Conditions for data selection)
  • added in section Conditions for data selection field definied as a list (you must set Datasource and SQL fields) - if You write in field SQL phrase mulitple: then definied as multiple choice lists, for example:

Version 3.1.29.h.r58-utf8 (2020-01-04)

  • added new version (4.7.11) of graphical library amcharts.
  • added new version of codemirror (v. 5.49) with:
    • string search
      • Ctrl-F - start search,
      • Ctrl-G - find next.
    • string replace
      • Shift-Ctrl-F - replace,
      • Shift-Ctrl-R - replace all.
  • added support for cifs/smb protocol (smbv2) - library jcifs-ng-2.1.3.jar.
  • fixed several bugs.

Version 3.1.29.h.r57-utf8 (2019-11-07)

  • added new JDBC drivers for Oracle DB (version 19.3).
  • fixed several bugs.
  • added variable $INSTDIR=explode("ProReports.utf8",$_SERVER["SCRIPT_FILENAME"])[0] in configuration file <proreports_dir>/webapps-plus/rep/version.php:

Thanks to this, the system automatically sets the system installation path and dependent paths.

$INSTDIR=explode("ProReports.utf8",$_SERVER["SCRIPT_FILENAME"])[0];
$UPLOADDIR=$INSTDIR ."ProReports.utf8/webapps-plus/rep/files"   ;
$REPORTDIR=$INSTDIR ."ProReports.utf8/webapps-plus/rep/reports" ;
$TEMPDIR=$INSTDIR   ."ProReports.utf8/webapps-plus/rep/temp"    ;
Important!

Do not rename the ProReports.utf8 directory!

Version 3.1.29.h.r56-utf8 (2019-09-25)

  • optimization of generating pdf files (caching attributes in an intermediate file with tags). Added attribute id for rows and cells (see here).
  • added function MagicStringSession() in configuration file.
Important!

To increase the level of security, change the salt value in the MagicStringSession() function in the file <proreports_dir>/webapps-plus/rep/version.php

  • added service for individual setting Kerberos Authentication (AD) for users (when variable KRB5AUTH is set to 1) - after registration of user You can set individual setting this variable for user.
    (for example You can set for all users Kerberos Authentication - $KRB5TYPES="AUMK" - but for user admin You can set local authentication).

Version 3.1.29.h.r55-utf8 (2019-08-21) very important change!!!

  • added annual limit of reports - sorry guys, but I need money for promotion, graphic designers and maintaining this site

Version 3.1.29.h.r54-utf8 (2019-06-26)

  • added in definition of field ListFieldZA and ListFieldZD option list sort in descending order
  • added extended role NOFETCH (in dictionary ROLE_EXT) - the coordinator does not normally have this permission (this mean that in Internal report coordinator can't use element NOFETCH - read about this element here) - administrator must to give this permission if he wants the coordinator to use this element. This can be helpful when defining a coordinator with limited privileges (for example a new employee).
  • little corrections in definition of fields

Version 3.1.29.h.r53-utf8 (2019-04-15)

  • added new jdbc driver for mariadb (v. 2.4.1)
  • in view Graf of elements added functions:
    • Add element - before - add element of report before indicated element
    • Add element - after - add element of report after indicated element
Caution!

New functions affect the ergonomics of work by creating of reports

  • in Internal reports changed max count of elements in level from 30 to 50

Version 3.1.29.h.r52-utf8 (2019-01-11)

  • in config file <proreports_dir>/webapps-plus/rep/version.php changed function __PROTIP(), __ADRESIP() and __PORTIP() to:
function __PROTIP($t="G"){ ($t=="L") ? $p="http://" : $p="http://"; return $p};
function __ADRESIP($t="G"){ ($t=="L") ? $h="127.0.0.1" : $h=$_SERVER["SERVER_NAME"] ; return $h };
function __PORTIP($t="G"){ ($t=="L") ? $p="8080" : $p="8080" ; return $p };

This give possibility of setting in docker version different global and local protocol, addres ip and port (first value is local value).

  • in config file <proreports_dir>/webapps-plus/rep/version.php added global variables : $ADRES_URL_LOC, $ADRES_HRM_LOC and $ADRES_HRM_INT_LOC
  • added new version of java library - javaxt-core.jar v.1.9.0

Version 3.1.29.h.r51-utf8 (2018-12-20) important change!!!

  • new driver JDBCBridge.class (v. 2.7)
  • added new drivers for mongodb (v. 3.4)
  • added jdbc driver SmallSQL (v. 0.21)

Version 3.1.29.h.r50-utf8 (2018-11-09)

  • added in simple reports support for Decimal fields with a precision of 4,6,8 decimal places

Version 3.1.29.h.r49-utf8 (2018-10-19) important change!!!

  • fix critical bug - recommended reinstallation
  • new UI implemented
  • added option NoFetch in Simple Report - if this option is set in field SQL executed before the report You can write PL/SPL procedure without return values

Version 3.1.29.h.r48-utf8 (2018-10-01)

  • added field Style in definition of window in dashboard
  • added dictionary CNAME_LST as realm of field Style
  • added predefined style w2ui-card
  • how make new style of window in dashboard see here
  • added style w2ui-dark as example of new style of window (see here)

Version 3.1.29.h.r47-utf8 (2018-09-26) important change!!!

  • new driver JDBCBridge.class (v. 2.6) - in definition of datasource in field Connect String after URL connection You can set properties in format {{name=value;[name=value]}}, for example:
jdbc:mysql://address_ip/database{{useUnicode=true;characterEncoding=utf8}}

Version 3.1.29.h.r46-utf8 (2018-09-06)

  • changed JRE to openjdk1.8.0_181 (due to licensing distortions from January 2019 with Oracle JRE) in full version (lite version is distributed without JRE)

Version 3.1.29.h.r45-utf8 (2018-09-03)

  • added security fixes

Version 3.1.29.h.r44-utf8 (2018-08-24)

  • added dashboards to normal users (type=U)
  • added option "Save" in definition of dashborad ("on" - option "Save" active in menu of dashboard, "off" - option inactive in menu of dashboard). Useful if you want make "static" windows in dashboard.

Version 3.1.29.h.r42-utf8 (2018-04-25)

  • added integration with AD (Active Directory) (Kerberos) -
    • conditions:
      • user must exist in ProReports and AD (same login),
      • user must have assigned roles in ProReports,
      • in default for authentication system retrieves the password for users (only types: U - user, K - Coordinator, M - Manager) from AD ($KRB5TYPES="UMK"),
      • in default password for administrators (type A) ProReports read localy (from database) ($KRB5TYPES="UMK").

Configuration:

  • in file <proreports_dir>/startrepo.sh (or startrepo.bat) should be set properties:
-Djava.security.krb5.realm
-Djava.security.krb5.kdc
-Dfile.encoding (change setting if AD have another codepage than UTF-8)

if AD have another codepage than UTF-8.

  • in file <proreports_dir>/webapps-plus/rep/version.php should be set variable:
    • $KRB5AUTH=1 (default is 0)
    • $KRB5CHARSET (if AD have another codepage than UTF-8)
    • $KRB5TYPES (types of users associated with AD: U - user, K - Coordinator, M - Manager, A - administrator) (default is "UMK") - for another password is readed localy from database.
Caution!

If You want block user in ProReports during editing the user set state: Not active.

Version 3.1.29.h.r41-utf8 (2018-04-06)

  • added new plugin - Base32
  • added new plugin - GoogleAuth:

Generating a secret key:

import GoogleAuth; 
$ga=new GoogleAuth(16) ; 
$V[key]=$ga->genEncKey(); 

Code verification:

import GoogleAuth; 
$ga=new GoogleAuth() ; 
$ga->setWindow(2)     ; 
$ga->checkCode($V[key],$P[code],$ga->getTime());

Version 3.1.29.h.r40-utf8 (2018-03-15)

  • added new tag in PDF Internal reports :
    • bookmark

Version 3.1.29.h.r39-utf8 (2018-02-13)

  • added new type of extention of report (JSON)
  • added framework AngularJS (version 1.6.7) (in directory <proreports_directory>/webapps-plus/rep/javascripts)
  • added examples of usage JSON and AngularJS in Internal reports

Version 3.1.29.h.r38-utf8 (2018-01-26)

  • elimination of less significant errors

Version 3.1.29.h.r37-utf8 (2018-01-03)

  • added new element DBUSE - set new datasource for all subelements of this element. This is simplest way to join data from another datasource to report.

Version 3.1.29.h.r36-utf8 (2017-12-14)

  • added new element ERROR - stop generation with error message (entered in field Expression/Code before Tamplate)
  • added new element EXIT - end of report
  • added new element DBCATCH - ignore database errors for all subelements of this element. All errors are in array $ITEMS[dbcatch_errors]
    • for example for element XX information about database error is in array $ITEMS[dbcatch_errors][XX]:
      • $ITEMS[dbcatch_errors][XX][item] - prefix of element
      • $ITEMS[dbcatch_errors][XX][error] - number of error
      • $ITEMS[dbcatch_errors][XX][error_sql] - SQL message error

Version 3.1.29.h.r35-utf8 (2017-11-20)

  • added new element WHILE by creating Internal reports. If You want repeat elements you can define element WHILE. Rules You must define in field Expression/Code before Tamplate, for example
$V[loop]+=1;
if ($V[loop]<=5) $status=1 ;
    else $status=0 ;

or

$V[loop]+=1;
if ($V[loop]<=5) $status=true ;
    else $status=false ;

or

$V[loop]+=1;
($V[loop]<=5) ? $status=true : $status=false ;

In this example all subelements of WHILE element will be repeated five times.

Version 3.1.29.h.r34-utf8 (2017-11-06)

  • new data layout in the window by creating reports (editing elements)

Version 3.1.29.h.r33-utf8 (2017-10-23)

  • added support for fields list by creating reports
  • added support for variables list by creating reports

Version 3.1.29.h.r32-utf8 (2017-09-04) important change!!!

  • added fade effect in forms
    If you want to turn off this effect in file <proreports_directory>/webapps-plus/rep/version.php> set variables as below:
  
  $HTTP_ENV_VARS["form_display_start"]="display: block;" ;
  $HTTP_ENV_VARS["form_display_finish"]="display: block;";

  • changed symbols for field type in tables with permissions ("N"=>"U", "O"=>"L")
  • after upgrade you must change permissions in database:
 update ge_repupr set typ='U' where typ='N';  
 update ge_repupr set typ='L' where typ='O';
 update ge_dicupr set typ='U' where typ='N';  
 update ge_dicupr set typ='L' where typ='O';  
 update ge_dashupr set typ='U' where typ='N';  
 update ge_dashupr set typ='L' where typ='O';
 update ge_formupr set typ='U' where typ='N';  
 update ge_formupr set typ='L' where typ='O';
 update ge_hrmupr set typ='U' where typ='N';  
 update ge_hrmupr set typ='L' where typ='O';
 update ge_dbupr set typ='U' where typ='N';  
 update ge_dbupr set typ='L' where typ='O';
  • add these sql commands to file <proreports_dir>/sql/backup.sql
  • run script <proreports_dir>db_backup.bat (or db_backup.sh)
  • delete these sql commands from file <proreports_dir>/sql/backup.sql

Version 3.1.29.h.r31-utf8 (2017-08-24)

  • added new version URLfork plugin (v. 1.3)
  • max length of login increased to 20 chars
  • added HTTP codes (400,401,403,404) to REST API (in files: rep_internal.php and rep_jasper.php)

Version 3.1.29.h.r30-utf8 (2017-08-11) important change!!!

  • security update
  • individual setting for PDF signing (per report)

Version 3.1.29.h.r29-utf8 (2017-07-10)

  • added support for encryption in pdf
  • added support for attachments in pdf
  • added new tags in PDF Internal reports :
    • hdrsts
    • sethdrsts
    • hdrdecode
  • fix few bugs

Version 3.1.29.h.r28-utf8 (2017-03-17)

  • added choice of data source in simple reports

Version 3.1.29.h.r27-utf8 (2017-02-13)

  • upgraded java JRE to version 1.8.0_121 (only full version),
  • functional separation jar libraries in the directories
    • javalib/proreports (libraries for ProReports),
    • javalib/jasper (libraries for jasper reports),
    • javalib/jdbc (JDBC drivers)
  • new line of ProReports - lite version

Information about differences between full and lite version search here.

Version 3.1.29.h.r26-utf8 (2017-02-06) - important change!!!

  • upgraded libraries for Jasper reports to version 6.0.4 (last version with java 6 support),

Version 3.1.29.h.r25-utf8 (2017-01-24)

  • added optional ZIP compression with password for files sending via email,
  • added optional GPG encryption and signing for files sending via email.
  • added field CheckBoxOnOff (HTML5) by creating form for report.

Version 3.1.29.h.r24-utf8 (2017-01-11)

  • ordering the graphic libraries - all the libraries placed in the directory <proreports_directory>/webapps-plus/rep/libgraph
  • added graphic library ChartJS (version 2.4.0)
  • updated graphic library AmChart (to version 3.20.19 - free version)

Version 3.1.29.h.r23-utf8 (2016-12-14)

  • added new engine (version 3.1.29h of serversms.jar) with support of encryption password for section <smtp>. You can encrypt password:
<proreports_directory>/<java_dir>/bin/java -jar serversms.jar -enc PASSWORD 

Copy output string (with "encrypted:") and set it in attribute password in section <smtp> in file repo.xml.

  • added default configuration for <smtp> section in file repo.xml. Thanks, if you have access to internet, you can test e-mails sending from ProReports.

Version 3.1.29.g.r23-utf8 (2016-12-01)

  • added in option Reports->Files of reports and Simple reports->Files of reports possibility to send e-mail with file of report to user (if e-mail is defined).
    If you have not configured smtp server you can off this feature in file webapps-plus/rep/version.php:
   $FILE_SEND_MAIL=0 
  • added in option Reports->Menu for report->E-mail support for special symbol: SEND@TO.USER. If you set this symbol in field E-mail after generation of reports file will be send to user automatically.
  • changed library JavaMail (new version: 1.5.6) with TLS support.

Version 3.1.29.g.r22-utf8 (2016-10-20)

  • added reports PNG and GIF (support UTF-8) (see sample TEST_PNG - report created as html is converting to image).
  • fix bug in library calendarDataInput.js by Jason Moon (calendar@moonscript.com) [ thank's Jason for a great component] - define variable this.selected in object.

Version 3.1.29.g.r21-utf8 (2016-10-03)

  • new driver JDBCBridge.class (v. 2.5)
  • added support of permissions to dictionaries and datasources (dictionary ROLES_EXT) - permissions set Administrator for Coordinators.

This gives a possibility to create a user that could create reports but only using the specified data sources.

  • added support of permissions to forms and dashboards (dictionary ROLES_EXT) - permissions set Administrator for Coordinators.
  • added support of permissions to scheduler (dictionary ROLES_EXT) - permissions set Administrator for Coordinators.

Version 3.1.29.g.r20-utf8 (2016-09-20)

  • added fade effect in main menu and browsers
    If you want to turn off this effect in file <proreports_directory>/webapps-plus/rep/version.php> set variables as below:
  
  $HTTP_ENV_VARS["mainmenu_display_start"]="display: none;"  ;
  $HTTP_ENV_VARS["mainmenu_display_finish"]="display: block;";

  $HTTP_ENV_VARS["browser_display_start"]="display: none;"  ;
  $HTTP_ENV_VARS["browser_display_finish"]="display: block;";

  • browsers optimization

Version 3.1.29.g.r19-utf8 (2016-08-03)

  • added spanish language
  • added language to assign to the user
  • any change in the datasource definition requires resetting the password (more secure than before)

Version 3.1.29.g.r18-utf8 (2016-05-11)

  • remove library ExtJS (windows in dashboards)
  • added library w2ui (with own modification - add element w2win based on w2popup) to display windows in dashboard
  • added ability to add javascript code to the dashboard (example in dashboard InterativeDash)
  • added in elements of dashboard options:

display as iframe - report in window is displayed as iframe (helpfull by HTML5 reports)

 and 

always up to date report - report always generated by openinig the window in dashboard (normally if found will file a report, it is displayed in the window, unless the use is described option, if You want want to display the panel report generated earlier unchanged, do not use this option)

  • fix few bugs
  • added JDBC drivers for:
    • Db2
    • MongoDB
    • FoxPro
    • Pervasive
    • AmazonRedshift

Version 3.1.29.g.r17-utf8 (2016-04-14)

  • new driver JDBCBridge.class (v. 2.4)
  • add JDBC driver sql4es-0.8.2.2.jar for elasticsearch from project GitHub/sql4es
  • add locale ru_RU (Russian version)
  • add script convert_lang.php (convert file messages.po with national characters to urlencode format)
  • add example of interactive dashboard

Version 3.1.29.g.r16-utf8 (2016-03-16)

  • fix of minor bugs
  • new graphics
  • implementation of CodeMirror editor

Version 3.1.29.g.r15-utf8 (2016-03-09)

  • added new global variable dashboard_bgcolor in <proreports_directory>/webapps-plus/rep/version.php>
  • added tooltips for all icons
  • changed menu and theme in dashboards
  • changed main menu
  • fixed error in option Dashboards->Copy

Version 3.1.29.g.r14-utf8 (2016-02-24)

  • added new global variable TEMPDIR in <proreports_directory>/webapps-plus/rep/version.php>
  • added new plugin QRCode
  • included library zxing (v.3.2.1)
  • added new report QRCode sample - example of creating a QR code

Version 3.1.29.g.r12-utf8 (2016-02-15)

  • new driver JDBCBridge.class (v. 2.3)
  • optimization function hex2bin
  • remove unnecessary libraries from libphp

Version 3.1.29.g.r11-utf8 (2016-01-08)

  • definition of internal report presented as graph (option Elements).

Version 3.1.29.g.r10-utf8 (2015-10-12)

  • adding a field of Button in forms. You can see examples of TestButton and TestButton1 forms to see how this type of field
    you can use in forms to their own reports.

Version 3.1.29.g.r9-utf8 (2015-09-23)

  • slight modification of the appearance of tables, buttons, forms

Version 3.1.29.g.r8-utf8 (2015-08-12)

  • included new version of library AmChart (version 3.15.2 HTML5, free) - charting library & maps in HTML5
  • add examples if use library AmChart in Internal reports and Dashboards

Version 3.1.29.g.r7-utf8 (2015-06-23)

  • fix bugs in option Elements->Diagram (Internal report)
  • fix bugs in option Elements->SQL (Internal report)

Version 3.1.29.g.r6-utf8 (2015-06-12)

  • add example with rotation of barcode image + usage of java library - javaxt-core.jar (BarcodeRotate)
  • add JDBC driver drill-jdbc-all-1.0.0.jar from project Apache Drill

Version 3.1.29.g.r5-utf8 (2015-05-26)

  • add example of report for NOFETCH element
  • add example of report for table with dynamic columns (TESTDYN)
  • minor changes in file files/main_Helper.php
  • minor changes in file locale/pl_PL/messages.po

Version 3.1.29.g.r4-utf8 (2015-04-27)

  • Minor changes in translation

Version 3.1.29.g.r3-utf8 (2015-04-15)

  • We add new type of element in Internal report - NOFETCH. If you set this type you can use in field SQL construction different than SELECT QUERY, fo example:
  CREATE TEMP TABLE <name_of_temporary_table>  AS SELECT * FROM <name_of_table> WHERE <conditions>
  or
  DROP TABLE <name_of_temporary_table> 
  or 
  UPDATE <name_of_table> ...
  or 
  DELETE FROM <name_of_table> WHERE <conditions>

This allows you to prepare pre-report data without writing a PL/SQL procedures.

Important!

Option is very dangerous due to the fact that you can use DELETE, UPDATE or DROP instruction in this element.

Version 3.1.29.g.r2-utf8 (2015-03-30)

  • Minor changes in translation
  • Changes in the definition css for menu buttons

Version 3.1.29.g.r1-utf8 (2015-03-23)

  • Minor changes in translation
  • In definition of internal report add cache type (memory, disk)
  • Improvement by generating a large reports

Version 3.1.29.g-utf8 (2015-03-18)

  • Minor changes in translation
  • Add xml type for output reports (Internal report)

Version 3.1.29.g-utf8 (2015-03-03)

  • Few bug fixes in simple reports

Version 3.1.29.g-utf8 (2014-02-11)

  • Adding font
    • kinnari.ttf - Thai
    • honokamin.ttf - Chinese

Version 3.1.29.g-utf8 (2014-01-19)

  • Adding formating for date. In file webapps-plus/rep/version.php You may set individual format for field DateField in forms.

You can set two variables: $DATE_FORMAT and $DATE_FORMAT_PHP.

Version 3.1.29.g-10 (2013-06-08)

  • Adding support transforms XSLT for fields in XML format.


This page may have a more recent version on pmwiki.org: PmWiki:ChangeLogProReports, and a talk page: PmWiki:ChangeLogProReports-Talk.

Edit - History - Print - Recent Changes - Search
Page last modified on November 04, 2020, at 02:53 PM EST