I am working on Android database type application. We need to show some reports.
My questions are:
1- How the reporting works on Android?
2- What are the good reporting tools to design and generate reports from SQLite data source?
3- How to generating pdf type reports from SQLite data source?
Regards.
What is a reporting tool? A reporting tool, or software reporting tool, is a system that takes in data from various sources and extrapolates it in tables, charts, visual presentations, and other styles so that the information is easier to parse.
Smartsheet, an online work execution platform, empowers organizations to plan, track, automate, and report on work. Over 80,000 brands rely on Smartsheet for project and work management because of its easy-to-use interface, real-time gantt charts and dashboards, and work automation features.
We can retrieve anything from database using an object of the Cursor class. We will call a method of this class called rawQuery and it will return a resultset with the cursor pointing to the table. We can move the cursor forward and retrieve the data. This method return the total number of columns of the table.
Currently there is no inbuilt reporting framework in Android @Rajdeep also mantioned it in his answer. So now we have these options:
1- Export data to a server, generate the reports on the server & download the reports back to your device.
2- Generate pdf type reports using tools like iText.
I am implementing the 2nd option. Please see this good example of how to create pdf documents.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With