B4J Question [SOLVED] Seeking Advice on Best Reporting Tool for B4J Migration

[jroriz]

Hello B4J Community,

I am in the process of migrating my ERP system from VB with Crystal Reports and MySQL to B4J. Reporting is a crucial component of my system, with some reports being quite complex, involving subreport concepts.

The most promising solution I’ve found so far for building reports in B4J is the JasperReports library (JasperReports Library) from 2021. However, I have concerns regarding the numerous dependencies of JasperReports, which may complicate the distribution of the executable and pose potential issues of obsolescence in the near future.

I am looking for a reporting solution that is simple to distribute and durable, avoiding the need for frequent upgrades. Despite following the example for JasperReports, I have not been successful, at least with version 2.

Could you please provide guidance on whether I am on the right path with JasperReports, or suggest better alternatives for report generation in B4J?

Thank you for your assistance!

 

[giannimaione]

some years ago https://www.b4x.com/android/forum/threads/jjasperreports-library.97475/post-614734
my test was a success

I don't know version 2
jasper report is very powerfull, but I preferred to use an alternative product (external B4J)

 

[BlueVision]

In principle, it depends on what exactly you mean by reports and how your system is set up. I know that this can become very complicated and complex with a corresponding number of elements and subelements in a database.
Personally, I would prefer a combination of an SQL-based database in conjunction with B4X tables for B4J. This keeps the whole construct simple and clear, at least as far as the visual representation is concerned. You can even automate the queries skilfully by automatically changing the query depending on additional control elements arranged next to the table. This is very convenient for the end user. A problem for the end user, however, could be the display of the tables. They are usually not scrollable, you have to "page" through the pages of the table.

Jasper is perhaps a little more convenient when it comes to importing from different sources and the corresponding export, but actually extracting this data from a B4X table or from the SQL database and converting it is not necessarily a problem, as long as the export format is not too proprietary or exotic.
All queries run via the SQL database, the results of the queries can be displayed immediately and very quickly in a B4X table, a B4X table itself can then even display the query data wihin the table in a modified form (e.g. when searching for keywords).

Persoannly I have no experience with Jasper. Maybe it is better, to use a SQL-based construct as base, pulling the reports with Jasper directly from that database and to use B4X tables for visual presentation, for other output use Jasper again.
The advantage: Your existing construct should be very easy portable from VB to B4X (B4J) and you could probably use all existing queries with small modifications.

NEXT REPORTS could be worth a look for your needs.

Cheers and good luck! BV

 

[Erel]

Check XLUtils. You can create an Excel or Word document and convert it to PDF.

 

[jroriz]

I believe JasperReports is the way to go. It is capable of handling complexities such as headers, footers, subtotals, totals, sub-reports, groups, etc. I will start with version 1 and see if I achieve success. Thanks to everyone.