rpt w/4 subreports (5 stored procs total) crViewer stops on first proc

[olichap]

I have a report created using the RDC and VB6 that contains 4 sub-reports. Each sub-report executes its own stored proc; there are 5 total. When my app initiates the print job and the report viewer is displayed, Crystal sends the first stored proc to SQL Server and stops, giving focus to the viewer as if the report is completed; it does not send all 5 one right after another.

The user can simply click on the go-to-last-page button in the viewer which will cause all the remaining stored procs to run sequentially.

Is there a way to cause the entire report to load (including subs) before the viewer is given focus and accepts user input?

Thanks,
Oliver

 

[dcm]

olichap: Have you set your subreports to be on-demand? If so it is this which is delaying their processing. Alternatively, check where in the main report your subs are placed as it may be that there is just too much data to get past before the subreports get executed although this is uncommon. None on-demand subreports should all execute in order to provide a report view - I notice you are using the RDC so check that your code does call for all subs to be executed at the right time David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Crystal Decisions Enterprise Partner

 

[olichap]

David,

I verified that my sub-reports were not set to on-demand. Each sub-report is in its own Report Footer section of the main report. Each of the five stored procs is querying a large database. Even when they do not return a great number of records the report viewer stops as each procedure completes, forcing user input before processing the next part of the report.

Oliver