We help IT Professionals succeed at work.
Get Started

Improving the crystal Report performance

RaoVP
RaoVP asked
on
1,141 Views
Last Modified: 2012-08-14
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?
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 42 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE