Android - What are the good reporting tools to design and generate reports from SQLite Data Source?

android sqlite pdf pdf-generation reporting
Yaqub Ahmad picture Yaqub Ahmad · Jan 17, 2012 · Viewed 19.9k times · Source

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.

Answer

Yaqub Ahmad picture Yaqub Ahmad · Jan 20, 2012

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.

Related questions

Can we store .doc .pdf and .jpg files in SQLite Database (Android)?

Is it possible to store files like pdf doc in SQLite db and the retrieve them again successfully.the files must be intact and readable again.I know we can store image files but for the above??. Even if we …

Read More
SQLite in Android How to update a specific row

I've been trying to update a specific row for a while now, and it seems that there are two ways to do this. From what I've read and tried, you can just use the: execSQL(String sql) method or the: …

Read More
How to delete all records from table in sqlite with Android?

My app has two buttons, the first button is for deleting record on user input and the second button is for deleting all records. But when I want to delete data it shows the message "Your application has been forcefully …

Read More