B4J Library jCrystalReports Library

Hi all.
I would like to share this jCrystalReports Library. (For now it supports MS SQL JTDS, MS SQL SQLJDBC, MySQL, Oracle and SQLite) I think I'm wrong, the java code in this library doesn't restrict to any jdbc connection and you can configure any jdbc in crystal reports as long is in the classpath (step 3). Please test everything.
Steps:
1. Copy all jdbc libraries to "C:\Program Files (x86)\Business Objects\Common\3.5\java\lib" (optional) or you just can specify jars' path explained in step 3.
2. Copy all crystal report jars to your B4j additional libraries folder. Link
3. In the CRConfig.xml you need to add the jars locations to <Classpath> under <DataDriverCommon> section using same format as all other entries (use \ and / in the path).
4. Also you need to change <JavaDir> from the dafault location to your Java JRE or JDK bin folder (it has to be the 32bit one). For example mine is "C:\Program Files (x86)\Java\jre1.8.0_181\bin". I found on the internet that the default java directory from crystal reports is not working.
5. In the CRConfig.xml configure <JDBC> section, modifying the following fields
<JDBCURL></JDBCURL>
<JDBCClassName></JDBCClassName>
<JDBCUserName></JDBCUserName>
with the required strings.
Example:
<JDBCURL>jdbc:sqlite:C:/YourPath/mydatabase.db</JDBCURL>
<JDBCClassName>org.sqlite.JDBC</JDBCClassName>
<JDBCUserName></JDBCUserName> This field is optional if no username is needed.
6. Create a Crystal Report using JDBC as your data connection. (If you can't find JDBC (JNDI) in your connections use your Crystal Reports installation program to add that feature).
7. Create a B4J project and add the following in the #Region Project Attributes:
#AdditionalJar: CrystalCommon2
#AdditionalJar: DatabaseConnectors
8. Open the example to fill all variables and launch the report.

I attached the library files, an example and a copy of my CRConfig.xml located in "C:\Program Files (x86)\Business Objects\Common\3.5\java" (could be "\4.0\java") as an example of my configuration.

v1.00 - Release.
v1.01 - Added methods PrintReport and ExportReport.
 

Attachments

  • jCrystalReports1.00.zip
    11.9 KB · Views: 850
  • crystalreportstest.zip
    2.3 KB · Views: 862
  • CRConfig.xml
    5.3 KB · Views: 978
  • jCrystalReports-1.01.zip
    30 KB · Views: 935
Last edited:
Click to expand...
roberto64

roberto64

Active Member
Licensed User
Longtime User
I haven't heard any more news, even if you have done well with the crystal report libraries, if you want to share the jcrystalreports matrix to expand, let me know bye
 
J

Juan Marrero

Active Member
Licensed User
Longtime User
roberto64 said:
I haven't heard any more news, even if you have done well with the crystal report libraries, if you want to share the jcrystalreports matrix to expand, let me know bye
Click to expand...
Sorry, I haven't got time to look into anything these days. To much work at home with a new house and a 10 month baby. Please understand. I can share the jCrystalReports eclipse project with you if you want.
 
B

BigBoss123

Member
Licensed User
Longtime User
roaddee said:
Update,
I used MariaDB 10.5.4 and success, all step from @Juan Marrero and @kelvo01 works excellent for me.
I only use the latest version of the connector, either mariadb or mysql
Click to expand...

Hi Roadee

That sound great.
I am trying to get this to work, and would appreciate if you could let me have the code you have used to get Crystal Reports and Mariadb to work.
Thanks ever for your help

David Donohue
 
roaddee

roaddee

Member
BigBoss123 said:
Hi Roadee

That sound great.
I am trying to get this to work, and would appreciate if you could let me have the code you have used to get Crystal Reports and Mariadb to work.
Thanks ever for your help

David Donohue
Click to expand...

I'll look for it first, because it's on my old laptop. I will share/reply soon on this forum.

Ikon Diverifikasi Komunitas
 
G

gallemodena

Member
Hi Juan,
the crconfig.xml file to which folder should it be copied? inside the file there are references in the <classpath> tag to many files that are not present in the attachments on Google Drive to, where can I find them? Thank you,
Christian
 
J

Jose Rojas

Member
Licensed User
gallemodena said:
Hola, Juan,
el archivo crconfig.xml a qué carpeta se debe copiar? dentro del archivo hay referencias en la etiqueta <classpath> a muchos archivos que no están presentes en los archivos adjuntos en Google Drive, ¿dónde puedo encontrarlos? Gracias,
cristiano
Click to expand...
Buanes Noches. Tienes Respuesta de esto? Tengo la misma duda.
 
J

Juan Marrero

Active Member
Licensed User
Longtime User
gallemodena said:
Hi Juan,
the crconfig.xml file to which folder should it be copied? inside the file there are references in the <classpath> tag to many files that are not present in the attachments on Google Drive to, where can I find them? Thank you,
Christian
Click to expand...
Check the first post, last instructions before the released versions.
 
G

gallemodena

Member
Hi Juan,
looking forward to trying to fix jasperreport issues, i'm attempting to use crystalreport (I had tried in the past but I didn't have time to continue testing)

I installed the XI version, I modified the CRConfig file and added all the libraries, but unfortunately it always gives me the same error:

"com.crystaldecisions.sdk.occa.report.lib.ReportSDKException---- Error code:-2147467259 Error code name:failed"

I tried many different connection strings (I think I understood from the web that the problem is inherent to the database connection) but it never returned a different error.


These are some of the many tried strings:
B4X: 
    Dim cr As CrystalReports
    
    cr.REPORT_NAME = "C:\Users\*****\Desktop\crystalreportstest\Objects\rptCli.rpt"
    cr.USERNAME = "sa"
    cr.PASSWORD = "*******"
    cr.TRUSTED_CONN = "false" 'or "true"
    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2\sqlexpress:50511;encrypt=false;databaseName=PM2MXL;integratedSecurity=false;user=sa;password=*******"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2\\sqlexpress;user=sa;password=*******;encrypt=false;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2\\sqlexpress:1433;user=sa;password=*******;encrypt=false;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2:1433\\sqlexpress;user=sa;password=*******;encrypt=false;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2\sqlexpress:1433;user=sa;password=*******;encrypt=false;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2:1433;instance=SQLEXPRESS;user=sa;password=*******;encrypt=false;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2:1433;instance=SQLEXPRESS;encrypt=false;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2:1433;instance=SQLEXPRESS;encrypt=true;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2/sqlexpress:1433;encrypt=true;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2//sqlexpress:1433;encrypt=true;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2//sqlexpress;encrypt=true;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2//sqlexpress;encrypt=true;databaseName=PM2MXL;integratedSecurity=false;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2//sqlexpress;encrypt=false;databaseName=PM2MXL;integratedSecurity=false;"
    
    
    
    'cr.CONN_URL = "jdbc:jtds:sqlserver://<servername>:<port>"
    cr.DB_NAME = "PM2MXL"
    cr.DB_CLASS_NAME = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    cr.SERVER_NAME = "SQLEXPRESS"
    cr.LaunchReport


Do you have any string examples for SQL Server? Or is the error due to something else?

Thanks again for any help you can give me,
Christian
 
J

Juan Marrero

Active Member
Licensed User
Longtime User
gallemodena said:
Hi Juan,
looking forward to trying to fix jasperreport issues, i'm attempting to use crystalreport (I had tried in the past but I didn't have time to continue testing)

I installed the XI version, I modified the CRConfig file and added all the libraries, but unfortunately it always gives me the same error:

"com.crystaldecisions.sdk.occa.report.lib.ReportSDKException---- Error code:-2147467259 Error code name:failed"

I tried many different connection strings (I think I understood from the web that the problem is inherent to the database connection) but it never returned a different error.


These are some of the many tried strings:
B4X: 
    Dim cr As CrystalReports
   
    cr.REPORT_NAME = "C:\Users\*****\Desktop\crystalreportstest\Objects\rptCli.rpt"
    cr.USERNAME = "sa"
    cr.PASSWORD = "*******"
    cr.TRUSTED_CONN = "false" 'or "true"
    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2\sqlexpress:50511;encrypt=false;databaseName=PM2MXL;integratedSecurity=false;user=sa;password=*******"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2\\sqlexpress;user=sa;password=*******;encrypt=false;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2\\sqlexpress:1433;user=sa;password=*******;encrypt=false;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2:1433\\sqlexpress;user=sa;password=*******;encrypt=false;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2\sqlexpress:1433;user=sa;password=*******;encrypt=false;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2:1433;instance=SQLEXPRESS;user=sa;password=*******;encrypt=false;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2:1433;instance=SQLEXPRESS;encrypt=false;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2:1433;instance=SQLEXPRESS;encrypt=true;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2/sqlexpress:1433;encrypt=true;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2//sqlexpress:1433;encrypt=true;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2//sqlexpress;encrypt=true;databaseName=PM2MXL;integratedSecurity=true;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2//sqlexpress;encrypt=true;databaseName=PM2MXL;integratedSecurity=false;"
'    cr.CONN_URL="jdbc:sqlserver://192.168.xxx.2//sqlexpress;encrypt=false;databaseName=PM2MXL;integratedSecurity=false;"
   
   
   
    'cr.CONN_URL = "jdbc:jtds:sqlserver://<servername>:<port>"
    cr.DB_NAME = "PM2MXL"
    cr.DB_CLASS_NAME = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    cr.SERVER_NAME = "SQLEXPRESS"
    cr.LaunchReport


Do you have any string examples for SQL Server? Or is the error due to something else?

Thanks again for any help you can give me,
Christian
Click to expand...
What sql server jdbc are you using? Microsoft's? Or the Open Source one?
 
You must log in or register to reply here.

Similar Threads

Erel
  • Article
B4J Code Snippet jtds jdbc driver with standalone package
Replies
6
Views
4K
Erel
Erel
P
  • Question
B4J Question #MergeLibraries:false - get list of libraries
Replies
2
Views
1K
prajinpraveen
P
Erel
  • Article
B4J Code Snippet Opening MS Access databases (mdb)
2
Replies
25
Views
15K
fernando.oliboni
F
agraham
  • Question
B4J Question Running jars under OpenJDK 11
2 3
Replies
41
Views
11K
agraham
agraham
J
  • Article
B4J Library jJasperReports Library
4 5 6
Replies
111
Views
27K
Juan Marrero
J
Top