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: 526
  • crystalreportstest.zip
    2.3 KB · Views: 551
  • CRConfig.xml
    5.3 KB · Views: 646
  • jCrystalReports-1.01.zip
    30 KB · Views: 597
Last edited:

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
 

Juan Marrero

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
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.
 

BigBoss123

Member
Licensed User
Longtime User
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

Member
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.

Ikon Diverifikasi Komunitas
 

gallemodena

New 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
 
Top