Slow report due to the subreport

[SuperTime]

Crystal 9
SQL Server database

I need to show the report totals on the top of the Group. And thats why I have a subreport with the exact same data but showing just the totals. which is placed in the group header. And the main report details sections shows the details.

And that is slowing down the report drastically, is there a solution for this? Note I have I have 10 and more different summary fields. So in one thread I saw a solution to create a shared array variables on the subreport... but that wont work for me cause I will have to create 15 shared array variables and even then not sure if that will help this performance issue?

Please advice...

Thanks

 

[pvidya]

Hi,

I expect you can total the fields in the detail section to the group level. Crystal automatically places these summary fields in the group footer. Then drag it up to the group header section. If this works, then you should not need the sub-report.

Thanks.

 

[SuperTime]

Sorry they are not summary fields, to be precise they are Running Totals and thats why I cannot just move it to the top.

 

[lbass]

Are you sure the running totals are necessary?

-LB

 

[pvidya]

Perhaps you can summarize the fields in a stored proc and include that in the report. You can display the summary fields in the group header and the detail level fields in the detail section.

 

[beltmanjr]

or think about creating a view (add command) that uses some sql to find these totals for you and so completely erasing them from your subreport?

 

[SuperTime]

The main report shows data for a date range where as I have the subreport that runs for a different date range to show the totals (the year to date data). And thats why I have to have a subreport, unless there is some other way to do this?

Please advice