B4J Library jCrystalReports Library

Juan Marrero · Sep 27, 2018

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.

Juan Marrero · Apr 11, 2019

roberto64 said:
https://drive.google.com/file/d/1kvY_8YYK_PuirgQqe5YbhYLpaQUB8AFo/view?usp=sharing

I used this link. I will try and look into it.

roberto64 · Apr 12, 2019

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

Juan Marrero · Apr 12, 2019

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

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.

roberto64 · Apr 12, 2019

Ok, so I'll try to prove it well, this is my email roberto1964.rt@gmail.com
regards

Juan Marrero · Apr 12, 2019

I tried it with the Jar files you sent me. Same behavior, same error.

roaddee · Nov 3, 2020

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

Juan Marrero · Nov 5, 2020

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

Glad to know.

BigBoss123 · Aug 22, 2021

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

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 · Aug 23, 2021

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

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

BigBoss123 · Oct 28, 2021

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

View attachment 118149

Any luck in finding the code??

cheers

David

gallemodena · Sep 22, 2022

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

Jose Rojas · Dec 13, 2022

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

Buanes Noches. Tienes Respuesta de esto? Tengo la misma duda.

Juan Marrero · Dec 13, 2022

Jose Rojas said:
Buanes Noches. Tienes Respuesta de esto? Tengo la misma duda.

Es la última instrucción antes de las versiones del primer post. C:\Program Files\Business Objects\...

Juan Marrero · Dec 13, 2022

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

Check the first post, last instructions before the released versions.

gallemodena · Jun 21, 2023

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

Juan Marrero · Jun 21, 2023

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

What sql server jdbc are you using? Microsoft's? Or the Open Source one?

B4J Library jCrystalReports Library

Attachments

Juan Marrero

Active Member

roberto64

Active Member

Juan Marrero

Active Member

roberto64

Active Member

Juan Marrero

Active Member

roaddee

Member

Juan Marrero

Active Member

BigBoss123

Member

roaddee

Member

BigBoss123

Member

gallemodena

Member

Jose Rojas

Member

Juan Marrero

Active Member

Juan Marrero

Active Member

gallemodena

Member

Juan Marrero

Active Member

Similar Threads

B4J Library jCrystalReports Library

Attachments

Active Member

Active Member

Active Member

Active Member

Active Member

Member

Active Member

Member

Member

Member

Member

Member

Active Member

Active Member

Member

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency