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.

FAQ for ProReports

1. How can i add my own font in PDF Internal report?
2. Can I read file *.csv in ProReports?
3. Can i change TimeZone in logs of ProReports?
4. How can i add my own driver JDBC?
5. Can i use in reports temporary tables?
6. Can i prepare report based on RTF template?
7. Can i prepare report with dynamic columns of table?
8. Can i use in reports stored procedures (PL/SPL)?
9. How can i prepare report based on blob field with xml?
10. How to set up SMTP server in ProReports?
11. Can i use in ProReports my own java library?
12. What types of barcodes supports ProReports?
13. Can I use ProReports to visualize analyzes of BigData?
14. How can i genarate QR Code in ProReports?
15. How can i configure secure connections in ProReports?
16. How can i change logo in simple report?
17. How prepare ProReports in their own language?
18. What can i do when start ProReports in Linux is very slow?
19. How can i turn off fade effect in main menu and browsers?
20. Can i change database indicated in report definition before the report generation?
21. How can i encrypt password for section <smtp> in file repo.xml?
22. How can i decrypt passwords from file repo.xml?
23. What is difference between full version and lite?
24. How run Proreports as docker container?
25. How create keystore file for signing of PDF?
26. How add new style of window in dashboard?
27. How add symbol: ' (apostrophe) in Internal report?
28. What to do if the data contains tags that collide with the tags used for generating pdf?
29. How can i read remote file from desktop computer?
30. How can i write file to remote desktop computer?
31. How add symbol: " (quota) in SQL?
32. Can I use Python language in ProReports?


1. How can i add my own font in PDF Internal report?

See here.


2. Can I read file *.csv in ProReports?

Yes. You can. You must define internal report with datasource REPO and add element with SQL:

SELECT * FROM CSVREAD("<name_of_file>","<field1>;<field2>;... or NULL if file with header","<encoding>","<separator>")

for example:

SELECT * FROM CSVREAD("/tmp/data.csv",NULL,"CP1250",";")
Important!

File must be available on ProReports server, for example in /tmp directory.

Alternatively you can use Apache Drill to read files *.csv.


3. Can i change TimeZone in logs of ProReports?

Yes. You must edit file <proreports_directory>/etc/jetty.xml. Search phrase GMT and change setting of timezone (java standard), for example Europe/Berlin or Africa/Casablanca or America/Los_Angeles etc.

List of timezones you can found here.


4. How can i add my own driver JDBC?

You must copy driver (file *.jar) to directory <proreports_directory>/javalib/jdbc and restart ProReports.


5. Can i use in reports temporary tables?

Yes. You should in Internal Report add element NOFETCH. In field SQL create temporary table (see example below):

CREATE TEMP TABLE <name_of_temporary_table>  AS SELECT * FROM <name_of_table> WHERE <conditions>
 In next elements you can use freely this temporary table. Of course you can create more temporary tables by adding further elements NOFETCH in reports.
Hint!

If you have very large tables you can try to use parallel quering mechanism by creating temporary tables. This will reduce the time required for filling a temporary table data.


6. Can i prepare report based on RTF template?

Yes. See here.


7. Can i prepare report with dynamic columns of table?

Yes. See example TESTDYN. This is only one of several method to prepare table with dynamic columns (in example i want to present element IFTHEN). But also You can, for example, write plugin PHP to constructing this kind of table and use it in ProReports or You can use some variable to remember part of code with markets in Internal Report.


8. Can i use in reports stored procedures (PL/SPL)?

Yes. You remember that if procedure does not return a value you must use element NOFETCH otherwise element SQL.


9. How can i prepare report based on blob field with xml?

See here.


10. How to set up SMTP server in ProReports?

See here.


11. Can i use in ProReports my own java library?

Yes. You must add this library to directory <proreports_directory>/webapps-plus/rep/WEB-INF/lib and restart ProReports. To use this library in Internal Report (in section Expression/Code before Tamplate or Expression/Code after Tamplate of element) you must use construction:



import <Name_of_library>.<My_Class>; 

$my_obj= new My_Class(param1, param2 [, param3]);
$my_obj->method1(param1 [, param2]) ;
$var=$my_obj->method2(param1 [, param2]);

See simple example.


12. What types of barcodes supports ProReports?

Below we published list of types supported in embedded java plugin ProBarcode:

  • Code39
  • Code128
  • Code128A
  • Code128B
  • Code128C
  • 2of7
  • 3of9
  • Bookland
  • EAN13
  • EAN128
  • Int2of5
  • Monarch
  • NW7
  • PDF417
  • PostNet
  • RandomWeightUPCA
  • SCC14ShippingCode
  • ShipmentIdentificationNumber
  • SSCC18
  • Std2of5
  • UPCA
  • USD3
  • USD4
  • USDS

See simple example.


13. Can I use ProReports to visualize analyzes of BigData?

Yes. We recommend using the Apache Drill through which you access BigData by using SQL commands. Driver JDBC of Apache Drill is embedded in ProReports (included in the version 3.1.29.g.r6-utf8).


14. How can i genarate QR Code in ProReports?

In the version 3.1.29.g.r14-utf8 was included library zxing (version 3.2.1) and new plugin QRCode with support for QR Codes. Look at report QRCode sample as example of creating a QR code in report or see article here.


15. How can i configure secure connections in ProReports?

How do that see here.


16. How can i change logo in simple report?

You must copy you own logo file logom.png to directory <proreports_directory>/webapps-plus/rep/files. Note the image size should be about 213x42 pixels.


17. How prepare ProReports in their own language?

system ProReports support multilingualism thereby you can prepare this system in your language. Below I describe shortly how do that.

1. You should create directory as name of local in directory <proreports_directory>/webapps-plus/rep/locale (for example nl_BE).

2. Than create in this directory new directory LC_MESSAGES.

3. In this directory you should make file messages.po on the pattern file <proreports_directory>/webapps-plus/rep/locale/pl_PL/LC_MESSAGES/messages.po with translations of all messages.

4. In dictionary LANGUAGES set new language.

5. Now You can set new language for any user.


18. What can i do when start ProReports in Linux is very slow?

Check setting variable securerandom.source in file <proreports_directory>/JRE/<jre_version>/lib/security/java.security:

Value file:/dev/random change to file:/dev/urandom

and than restart server ProReports.


19. How can i turn off 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;";


20. Can i change database indicated in report definition before the report generation?

Yes. See here.


21. How can i encrypt password for section <smtp> in file repo.xml?

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.


22. How can i decrypt passwords from file repo.xml?

 See here.

23. What is difference between full version and lite?

In the lite version is not included openjdk (directory JRE), some JDBC drivers (eg. drill-jdbc-all-1.0.0.jar, sql4es-0.8.2.2.jar) and the graphics library ammap_3.20.19.free.


24. How run ProReports as docker container?

See here.


25. How create keystore file for signing of PDF?

See here.


26. How add new style of window in dashboard?

See here.


27. How add symbol: ' (apostrophe) in Internal report?

You can write symbol: ' (apostrophe) as \x27


28. What to do if the data contains tags that collide with the tags used for generating pdf?

Change characters < and > to &#60; and &#62;, for example:

  • element A
SectionValue
SymbolA
TypeBODY
Weight0
Parent---
DescriptionField with html tags
SQLSELECT html_field FROM table
Expression/Code before Template$V[A_html_field]=preg_replace(array("<",">"),array("&#60;","&#62;"),$F[A_html_field]);
Template
<NEXT-ITEM>
<TABLE>
<TR nobr=0 border=1 bgcolor=-1 color=0 font-style= font-size=8 height=5>
<TD width=20 align=C color=0>$V[A_html_field]</TD>
</TR>
</TABLE> 
Expression/Code after Template 

29. How can i read remote file from desktop computer?

See here.


30. How can i write file to remote desktop computer?

See here.


31. How add symbol: " (quota) in SQL?

You can write symbol: " (quota) as &#34;. If You want write to database value: &#XXX; you set &#38;#XXX; where (XXX - value from 0 to 999).


32. Can I use Python language in ProReports?

Yes. See here.


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

Edit - History - Print - Recent Changes - Search
Page last modified on August 28, 2020, at 03:24 PM EST