troubleshooting Question

Improving the crystal Report performance

Avatar of RaoVP
RaoVPFlag for United States of America asked on
Crystal Reports
42 Comments1 Solution1145 ViewsLast Modified:
Hi,
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?
ASKER CERTIFIED SOLUTION
David11Norman

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 42 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 42 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros