Hi,
I created a report with 10 graph. And 4 dropdown list (year, month, structure and indicator).
But when I change one of the value of a dropdown list the report take near to 1 minute to make the modification in the graph.
I use one query to populate every dropdown list (so 4 query)
And 4 other query to my graph, with all query have different filter.
I try two way, by query extract my data from my database.
And I try to create a package.
By these two way I have approximatly the same time to generate the report.
Do you know why the report take so much time ?
To much graph on the report ? To much query ?