Hello everyone, I need to build some sort of mobile "dynamic" reports

Hello everyone, I need to build some sort of mobile "dynamic" reports for my customers, ie the end user should be able to select a region, a group and a period and get a table and a bar chart back (through chained tasks). Most data are stored in the data store but additional fields need to be computed at the time of the report. I have been thinking of few design options but I am not quite sure about them. Could you give me some advices/ provide other options? Can I somehow use the new records, tempo chart functionalities?
For now, I am inclined to :
- create a view (CDT1) to select the data subset that I need to report on or that is required to compute additional fields
- query CDT1 with conditions provided by end users
- build a data subset (CDT2) with looping functions to include computed values
- Create the chart with the chart creator plugin
- Display the CDT2 in a paging grid and the chart in an image field
Another option is to use the exe...

OriginalPostID-69657

OriginalPostID-69657