Crystal Report Server Java

English | 简体中文

An Crystal Report server run in java.

Linux System Prepare

1. Copy fonts to$JAVA_HOME/lib/fonts, and set permission to this folder

   sudo chmod -R $JAVA_HOME/lib/fonts 755
   

2. Create fonts index, and update fonts cache (As Required)

   • CentOS

   yum install -y fontconfig mkfontscale
   mkfontscale && mkfontdir && fc-cache -fv
   

   • Ubuntu

   sudo apt-get -y install fontconfig xfonts-utils
   mkfontscale && mkfontdir && fc-cache -fv
   

3. Allow the TLS disabled algorithms (As Required) If the connect database version is too old, and the running Linux system is new, you maybe will have the TLS connection issue by disabled algorithms.

   EditJAVA_HOME/conf/security/java.security, Delete dk.tls.disabledAlgorithmsdisabled algorithms value； Edit/etc/crypto-policies/back-ends/java.config, Delete jdk.tls.disabledAlgorithmsdisabled algorithms value；

How to Use

1. It contains postgres，mysql， sql server driver by default, Add your db driver in pom.xml as necessary.
2. At the target running folder, upload target\lib(it contains all dependencies), upload *.rpt files to reports folder.
3. update your database url, driverClassName, user, password, report location in config-prod.
4. At the target running folder, Run java -jar crystal-report-server-java.jar --conf=config-prod.json or Run java -jar crystal-report-server-java-fat.jar --conf=config-prod.json.
5. Open http://server:port/Report/{ReportTemplateName}/{format}?param0=val0&param1=val1 in browser, you can see your report.

Note: {ReportTemplateName} is the name of your report template file without extension, {format} is the format you want, such as pdf doc xls, param0 and param1 are the parameters of your report, give a param named with filename, this param value will be used as the file name. Suggestion: Using Command SQL instead of Table Link for better performance, reduce the report generation duration.