I do have the problem running the report for the larger dataset like for eg: Six Months worth of data
1)The report is been pulled from the cursor
2) There are no record selection on the report side, everything is done on the Database Query
3) I am using Array for printing the results
4) I do have 8 levels of grouping, in which first 2 grouping's and last 2 grouping's (four grouping) are harded coded eg: they run everytime when the report run , But the remaining grouping are 3,4,5,6 are picked from the UI.if there is no grouping picked then report only runs for remaining 4 groups
I am calling the crystal report through a URL and URL is directly hitting the crystal server.
what i have been observing is that its reading all the records and then grouping on the report side and then printing the first page.
grouping on the server option is graded out .
How can i improve the performance of the report?