B4J Library jJasperReports Library

Roberto P. · Sep 21, 2018

can you post some images?
thank you

Juan Marrero · Sep 21, 2018

Roberto P. said:
can you post some images?
thank you

Posted.

If you downloaded jaspertest.zip, please download it again. I copy/pasted something that ended in an error loading .jasper file.

afields · Sep 22, 2018

very nice!. is it possible to connect also with sqlite?
thank you.

XbNnX_507 · Sep 22, 2018

afields said:
is it possible to connect also with sqlite?

Same question here.

Juan Marrero · Sep 22, 2018

afields said:
very nice!. is it possible to connect also with sqlite?
thank you.

Will look into it.

Juan Marrero · Sep 22, 2018

Added new Library including sqlite support and a screenshot of the sqlite report on the first post. SQLite version used was sqlite-jdbc-3.23.1.jar.

giannimaione · Sep 23, 2018

wow,
it works very well!

my report use MySql,
what does it mean, in log ?

B4X:

Sun Sep 23 20:09:17 CEST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

set 23, 2018 8:09:19 PM net.sf.jasperreports.engine.export.PdfGlyphRenderer determinePatchedItext

AVVERTENZA: Unpatched iText found, cannot use glyph rendering

afields · Sep 23, 2018

hello. sorry by the new library that was added is an update of one that's already here?. because i cannot locate that new library.
Thank you but anyway it's a very nice library

Juan Marrero · Sep 23, 2018

giannimaione said:

wow,
it works very well!

my report use MySql,
what does it mean, in log ?

B4X:

Sun Sep 23 20:09:17 CEST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

set 23, 2018 8:09:19 PM net.sf.jasperreports.engine.export.PdfGlyphRenderer determinePatchedItext

AVVERTENZA: Unpatched iText found, cannot use glyph rendering

Forgot about that. I'll add a variable to set useSSL true or false. If MySQL is configured with SSL and you try to connect without specifying useSSL=false MySQL doesn't let you connect (most of the time).
The Unpatched iText Warning is because JasperReports use a modified iText library.

Juan Marrero · Sep 23, 2018

afields said:
hello. sorry by the new library that was added is an update of one that's already here?. because i cannot locate that new library.
Thank you but anyway it's a very nice library

I replaced the original upload with the new one. The initial library was deleted. Next time I'll leave the old library and add the new one as a different upload.

afields · Sep 24, 2018

hello to all!
Very cool that library. i've tried with sqlite (it's the one that i have more records) and also few reports designed with jasper. Each of those reports also have parameters. using jasper.parameters it's working very well.

Juan Marrero · Sep 24, 2018

@giannimaione I added a new version of the library where you can set useSSL to false when connecting to MySQL. I also checked the JasperDesign and JasperDesignQuery functions and made them work (I used an example from internet which causes errors compiling the report but now works). Using JasperDesign and JasperDesignQuery you can change the report's query design at runtime.

Juan Marrero · Sep 24, 2018

afields said:
hello to all!
Very cool that library. i've tried with sqlite (it's the one that i have more records) and also few reports designed with jasper. Each of those reports also have parameters. using jasper.parameters it's working very well.

Glad to hear that!

Juan Marrero · Oct 11, 2018

v.13 - Added a way to print directly to selected printer.

B4X:

Dim jasper As JasperReports
   Dim report As JasperReport
   Dim print As JasperPrint
   Dim conn As JasperConnection
   Dim design As JasperDesign
   Dim query As JasperDesignQuery
   
   Dim printers As List = Printer_Static.GetAllPrinters
   Dim printersList As List
   
   printersList.Initialize
   
   For Each prt As Printer In printers
       printersList.Add(prt.GetName)   
   Next
   
   Dim selPrinter As String
   
   Dim sel As Int = fx.InputList(MainForm, printersList, "Select Printer:", "Printer", -1)
   
   If sel <> fx.DialogResponse.CANCEL Then
       selPrinter = printersList.Get(sel)
   End If
   
   jasper.InitializeParameters
   jasper.InitializeJasperDesign
   jasper.GetResourceAsStream(File.Combine(File.DirApp, "mysql_example.jrxml"))
   jasper.LoadJRXml(jasper.in)
   jasper.InitializeJRDesignQuery
   jasper.SetText("select reference, code, name, pricesell from products where name like '%SQL' order by name asc")
   query = jasper.query
   jasper.SetJRDesingQuery(query)
   design = jasper.design
   report = jasper.CompileXML2(design)
   conn = jasper.getConnectionMySQL("localhost", "3306", "databasename", "user", "password", False) 'useSSL = true or false
   print = jasper.Print(report, jasper.parameters, conn)
   
   If selPrinter <> "" Then
       jasper.PrintDirectlyToPrinter(print, selPrinter, jasper.msn_NA_LETTER)
   Else
       jasper.JasperViewer(print, True)
   End If

I used jFX8Print library to select the printer name.

Mohamed Kamel · Oct 18, 2019

Hello Please Help Me In This Issue Am Using An Arabic Text In My Report When I Export The pdf File From I report It Showing It Correctly But When I Add The Report To The Project And Run It I Got This Error

B4X:

net.sf.jasperreports.engine.util.JRFontNotFoundException: Font "DejaVu Sans Mono" is not available to the JVM. See the Javadoc for more details.

Juan Marrero · Oct 21, 2019

Mohamed Kamel said:
Hello Please Help Me In This Issue Am Using An Arabic Text In My Report When I Export The pdf File From I report It Showing It Correctly But When I Add The Report To The Project And Run It I Got This Error

B4X:

net.sf.jasperreports.engine.util.JRFontNotFoundException: Font "DejaVu Sans Mono" is not available to the JVM. See the Javadoc for more details.

Sorry for late response, my 1 year old daughter consumes most of my time. If I got this correctly, if you prepare the report and do a preview the report shows OK, but when you tried it from B4J Project it gives an error. Am I correct?

afields · Oct 21, 2019

hello! i'm sorry but i've a situation also that i cannot resolve. it's in https://www.b4x.com/android/forum/threads/calculated-field-in-a-jasper-report.109717/.
Can you help me?
Thank you!

Juan Marrero · Oct 21, 2019

afields said:
hello! i'm sorry but i've a situation also that i cannot resolve. it's in https://www.b4x.com/android/forum/threads/calculated-field-in-a-jasper-report.109717/.
Can you help me?
Thank you!

I wrote something on your thread.

Juan Marrero · Oct 29, 2019

Mohamed Kamel said:
Hello Please Help Me In This Issue Am Using An Arabic Text In My Report When I Export The pdf File From I report It Showing It Correctly But When I Add The Report To The Project And Run It I Got This Error

B4X:

net.sf.jasperreports.engine.util.JRFontNotFoundException: Font "DejaVu Sans Mono" is not available to the JVM. See the Javadoc for more details.

I sent you a private message with a new library for you to test.

B4J Library jJasperReports Library

Attachments

Well-Known Member

Active Member

Member

Active Member

Active Member

Active Member

Well-Known Member

Member

Active Member

Active Member

Member

Active Member

Active Member

Active Member

Member

Active Member

Member

Active Member

Active Member

Similar Threads