Report tools.

[saulhidalgoaular]

Saul POS should have a way to generate reports in PDF, Excel, CSV, Word, etc.

I propose using dynamic report library (https://dynamicreports.org/). Dynamic Reports requires column specifications and some data source.

Idea is to find a way to the user to specify the columns and way to query the database.

Sample reports to create:

• Total Products
• Negative Products
• Inventory movements (invoice and credit notes) by Date or Product.
• Invoices with Discount.
• Invoices by Date
• Credit Notes by Date

[saulhidalgoaular]

https://github.com/FXMisc/RichTextFX

[saulhidalgoaular]

https://www.digitalocean.com/community/tutorials/hibernate-native-sql-query-example

[saulhidalgoaular]

https://github.com/FXMisc/RichTextFX/tree/master/richtextfx-demos

[saulhidalgoaular]

It is needed to add a RichTextFX Library to make the Query colourful. Please, check the examples given in the comments.