Drill-down speed

[Former Member]

I have lots of reports with multiple levels of drill down. When I run these reports in CR Developer, the drilling is instantaneous, practically.

However -- when the reports are run from the website from whence my user's access them -- drilling seems to require a complete requery of the data.

Is there any way to eliminate this requery? To query once at report load, and then use "saved" data for any drilling?

[Former Member · Accepted solution]

Add the special field "n of m" to the report. this will cause the report to get processed completely. Without the field, only the page viewed is processed.

Also, you may want to consider using session as described in the article [Crystal Reports For Visual Studio 2005 Walkthroughs|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/2081b4d9-6864-2b10-f49d-918baefc7a23], p. 107+

Ludek