FinghtingMiao
asked on
How to improve reports performance
I created a crystal reports with 6 build-in subreports, using 5 different BW queries, having 30 formulas. including graphs. It takes more 40secs to run this repors.
But how can I improve the report performance on crystal report side?
Many thanks in advance!
But how can I improve the report performance on crystal report side?
Many thanks in advance!
ASKER
Thanks
I did not do the record selection on Crystal side.
what I have are 6 subreports all linked to the main reports.
In the main reports I use lots of formula and send shared value to sub reports for further caculation.
Each subreports still have around 20 formula.
In the main report I used 5 different queries.
All the 6 subreports parameters changed link to main report parameters.
Thansk u very much!
I did not do the record selection on Crystal side.
what I have are 6 subreports all linked to the main reports.
In the main reports I use lots of formula and send shared value to sub reports for further caculation.
Each subreports still have around 20 formula.
In the main report I used 5 different queries.
All the 6 subreports parameters changed link to main report parameters.
Thansk u very much!
Record selection is generally the key to speeding a report.
40 seconds isn't too long for generating 7 reports.
Are the subreports generatd once?
mlmcc
40 seconds isn't too long for generating 7 reports.
Are the subreports generatd once?
mlmcc
ASKER
Yes, all the subreports generated once.
Thanks u
Thanks u
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I got u . Thanks.
But if i run the last instance for that report and generated a link like
https://********/businessobjects/enterprise115/sap/InfoView/scripts/opendocument.aspx?sDocName=4AYLE6WDL9VW7RNXE71ZZ2T88&sType=rpt&sInstance=Param
it still take 25-30 secs.
Suppose If I call the last instance from the link, the report should be show up in 2 secs. but by it still take 25-30 secs to run the last instance?
Thank u very much !
Grace
But if i run the last instance for that report and generated a link like
https://********/businessobjects/enterprise115/sap/InfoView/scripts/opendocument.aspx?sDocName=4AYLE6WDL9VW7RNXE71ZZ2T88&sType=rpt&sInstance=Param
it still take 25-30 secs.
Suppose If I call the last instance from the link, the report should be show up in 2 secs. but by it still take 25-30 secs to run the last instance?
Thank u very much !
Grace
If you need help or aren't sure if they can be sent to the server post the record selection
Are the subreports linked to the main report?
mlmcc