B4J Library jJasperReports Library

Juan Marrero · Sep 21, 2018

Hi. I want to share this jJasperReports library with the community.
It needs several libraries to work. I provided a link: ~~download~~
---More libraries needed (missing from the first link): ~~download~~
You also need to download databases jdbc drivers: ~~sql jdts, mysql and oracle~~
New Link (All jar files are included in this link): Download
All jars need to be placed in Additional Libraries folder.
In the B4J project you need to add a jar file: #AdditionalJar: itext-2.1.7.js1
Library files and a small example is provided.
Please feel free to test the library.
Note: for some reason when using SubReports, the compiled (.jasper) files need to be in the same level as the app jar file. XML Reports (.jrxml) can be in any other folder different from the app jar file. (e.g. if report.jrxml is in File.DirApp & "/reports" then all compiled (.jasper) subreports need to be in File.DirApp. In the example provided .jrxml and .jasper are in the same level as jaspertest.jar.

v1.00 - Release
v1.10 - SQLite support added. MySQL useSSL variable added.
v1.12 - Changed the way the JasperViewer works. Now you can set the form to full screen, use the default size and location or set a specific size and location.
v1.13 - Added method PrintDirectlyToPrinter.
v1.20 - Access support added via uCanAccess jdbc driver. Note: When creating reports in Jaspersoft Studio you need to add all jar files that ucanaccess needs. The metadata won't work but you can create a query and it will work.
v1.22 - Added functions to export report to XLS and XLSX. Note: need 2 more jar files: download. Copy them into Additional Libraries folder.
v1.24 - Added function Print3 to be able to show reports without a Data Source.

------------------------------------------

NEW VERSION 2.00
Special thanks to Num3 for testing this library and helping me getting it done.

Instructions:
1. Libraries needed: Donwload
2. Place all jars in Additional Libraries folder
3. Specify in B4J project with #AdditionalJar: the database that is going to be used. (e.g. #AdditionalJar: mysql-connector-java-5.1.49-bin)
a. If using ucanaccess-5.1.0 database please add these in addition to #AdditionalJar: ucanaccess-5.0.1:
- #AdditionalJar: commons-lang3-3.8.1
- #AdditionalJar: commons-logging-1.2
- #AdditionalJar: hsqldb-2.5.0
- #AdditionalJar: jackcess-3.0.1

v2.00 - Same functionality as v1.24 but based on jasperreports-6.17.0. Previous v1.24 was based on jasperreports-6.7.1.

Situ LLC · Jun 15, 2020

Thanks to share
Caused by: java.io.FileNotFoundException: C:\PREC72~1\JASPER~1\Objects\RepName.jrxml ( The system cannot find the specified file)
I was able to runt the test , I couldn't create these mentioned files missing, something else is missing , there are more examples and literature ?
Thanks

Juan Marrero · Jun 15, 2020

busmatic said:
Thanks to share
Caused by: java.io.FileNotFoundException: C:\PREC72~1\JASPER~1\Objects\RepName.jrxml ( The system cannot find the specified file)
I was able to runt the test , I couldn't create these mentioned files missing, something else is missing , there are more examples and literature ?
Thanks

You have to create the reports (.jrxml) with tools like Tibco Jaspersoft Studio. I use Tibco Jaspersoft Studio Community Edition.

Situ LLC · Jun 15, 2020

Thnks

behnam_tr · Feb 1, 2021

hi
problem with arabic characters in export pdf
solved??

Juan Marrero · Feb 1, 2021

behnam_tr said:
hi
problem with arabic characters in export pdf
solved??

I looked into old private messages and at least I solved it using DejaVu font. I first tried with Arial but didn't worked. Only worked with DejaVu. It's included in versions newer than 1.20.

behnam_tr · Feb 2, 2021

Juan Marrero said:
I looked into old private messages and at least I solved it using DejaVu font. I first tried with Arial but didn't worked. Only worked with DejaVu. It's included in versions newer than 1.20.

thanks i test DejaVu font and is ok in pdfexport
but i want to use other fonts,any other truetype fonts

sample and font attached

Juan Marrero · Feb 2, 2021

behnam_tr said:
thanks i test DejaVu font and is ok in pdfexport
but i want to use other fonts,any other truetype fonts

sample and font attached

In theory any fonts that support Arabic symbols (characters) should work. Since I live in Puerto Rico (US Territory) I don't know any fonts (outside DejaVu) that support Arabic characters (or any other language that is not Spanish or English). I will download your testJasper.zip file and I will try to look into it.

Juan Marrero · Feb 2, 2021

On a quick review, DejaVu fonts are inside jasperreports-fonts-6.0.0.jar. So I'm guessing if it's possible to include your font into a jar, I could add it to the library.

behnam_tr · Mar 12, 2021

Juan Marrero said:
On a quick review, DejaVu fonts are inside jasperreports-fonts-6.0.0.jar. So I'm guessing if it's possible to include your font into a jar, I could add it to the library.

thanks for help....
i could add other font that support persian or arabic characters
and Now pdfExport Is Ok for B Titr Font .that is a trueType Font
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
For addind Your TrueType Fonts

1..open jasperreports-fonts-6.0.0.jar Wiht 7-zip software

2.add your fonts to >> net/sf/jasperreports/fonts

3.open fonts.xml with notepad and add this codes

B4X:

<fontFamily name="B Titr">
        <normal>net/sf/jasperreports/fonts/myfonts/BTitr.ttf</normal>
        <bold>net/sf/jasperreports/fonts/myfonts/BTitr.ttf</bold>
        <italic>net/sf/jasperreports/fonts/myfonts/BTitr.ttf</italic>
        <boldItalic>net/sf/jasperreports/fonts/myfonts/BTitr.ttf</boldItalic>
        <pdfEncoding>Identity-H</pdfEncoding>
        <pdfEmbedded>true</pdfEmbedded>
        <exportFonts>
            <export key="net.sf.jasperreports.html">'B Titr', Arial, Helvetica, sans-serif</export>
            <export key="net.sf.jasperreports.xhtml">'B Titr', Arial, Helvetica, sans-serif</export>
        </exportFonts>
        
    </fontFamily>

4.Open and edit "jasperreports_extension.properties" file and add this line code

B4X:

net.sf.jasperreports.extension.simple.font.families.myfonts=net/sf/jasperreports/fonts/fonts.xml

5.in iReport software set label font property like attached image (I'm Using iReport 5.2.0)

6.Done.

focus330 · Apr 7, 2021

HI
I created some reports with TIBCO. One of them has a picture ( a png image ). Exporting this report as Report Template the app exports also the image.
Calling GasperViewer from b4j i have this error :
net.sf.jasperreports.engine.JRException: Byte data not found at: flower1.png.
What means ? What is wrong ?
Thanks

Juan Marrero · Apr 7, 2021

focus330 said:
HI
I created some reports with TIBCO. One of them has a picture ( a png image ). Exporting this report as Report Template the app exports also the image.
Calling GasperViewer from b4j i have this error :
net.sf.jasperreports.engine.JRException: Byte data not found at: flower1.png.
What means ? What is wrong ?
Thanks

Did you put flower1.png at the same level as your report?

Situ LLC · Apr 8, 2021

I have the same ..

Juan Marrero · Apr 8, 2021

busmatic said:
I have the same ..

I don't recall if the example provided have the SQLite Button. In that button's code there is an example of how to include pictures in the report. In early versions of the library you had to put it at the same level as the report but now you can specify where the picture is (I totally forgot about that).

B4X:

    Dim jasper As JasperReports
    Dim report As JasperReport
    Dim print As JasperPrint
    Dim conn As JasperConnection
   
    jasper.InitializeParameters
    report = jasper.CompileXML(File.Combine(File.DirApp, "sqlite_test.jrxml"))
    jasper.AddParameter("realPath", File.Combine(File.DirApp, "cherry.jpg"))
    conn = jasper.getConnectionSQLite(File.Combine(File.DirApp, "jasperTest.db"))
    print = jasper.Print(report, jasper.parameters, conn)
    jasper.JasperViewer(print, True)

I created a Parameter called realPath as String.

In the image properties (under Image Tab) in Expression I selected the parameter "realpath". Please click on the "Form+Pencil" button to enter Expression Editor to select the Parameter.

focus330 · Apr 9, 2021

Thanks. Perfect.

Situ LLC · Apr 9, 2021

Thanks

Xfood · Apr 26, 2021

Juan Marrero said:
Hi. I want to share this jJasperReports library with the community.
It needs several libraries to work. I provided a link: download
---More libraries needed (missing from the first link): download
v1.22 - Added functions to export report to XLS and XLSX. Note: need 2 more jar files: download. Copy them into Additional Libraries folder.
v1.24 - Added function Print3 to be able to show reports without a Data Source.

Good morning,
sorry, these links to download the additional libraries are no longer active, I can't download the libraries,
could someone make available a zip file with all the necessary libraries?
Thanks a lot to everyone

inakigarm · Apr 26, 2021

Xfood said:
Good morning,
sorry, these links to download the additional libraries are no longer active, I can't download the libraries,
could someone make available a zip file with all the necessary libraries?
Thanks a lot to everyone

This works fine here ... https://www.b4x.com/android/forum/attachments/jjasperreports-1-24-zip.107018/

Xfood · Apr 26, 2021

thank you

Xfood · Apr 26, 2021

sorry, I needed all the additional libraries

Juan Marrero · Apr 26, 2021

Xfood said:
Good morning,
sorry, these links to download the additional libraries are no longer active, I can't download the libraries,
could someone make available a zip file with all the necessary libraries?
Thanks a lot to everyone

You sure? They worked for me.

B4J Library jJasperReports Library

Attachments

Active Member

Active Member

Active Member

Active Member

Active Member

Active Member

Attachments

Active Member

Active Member

Active Member

Attachments

Member

Active Member

Active Member

Active Member

Member

Active Member

Expert

Well-Known Member

Expert

Expert

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency