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

Question

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.

Solution 1

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.

Solution 2

Take a look at PDFReporter at www.pdfreporting.com There is also a open source project "PDFReporter" on sourceforge as well.

Solution 3

i m still in process of generating report in android... while using iText 5.2 library i have came across so many issues like compatibility betn android and java ...

i think u should generate report in doc format

Solution 4

There is no inbuilt reporting framework in Android. You will have to write custom code to generate the relevant reports.

One option is to backup the data to a server and use third party reporting tools on it.

View more solutions

Comments

[Yaqub Ahmad]

How about generating pdf type reports, it will kill the application performance?

[Paul Jowett]

If your application can make use of an online-service then Docmosis Cloud might help since it can offload the document-generation process so your application has less work to do, but you have latency over networks.

[Houcine]

i think that now there is an API for generating reports in Android , check this out :) : community.jaspersoft.com/project/jaspermobile-android/releas‌​es