Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CR8 using TopnSort with a Subreport

Status
Not open for further replies.

schusser

Programmer
May 18, 2000
48
US
I'm doing a top 50 report using a single SQL table. The report has 2 subreports.
It takes forever to run and print. Appears to be reprocessing the SQL procedure for each section of the report, hence 150 times.
The 2 subreports are displaying data as a percent of a summarized field in the main report.
Is this the wrong approach? Is there a way to speed things up?

Thanks
 
Don't use the topN feature, unless you have a very small database or a lot of time. A stored procedure that returns the just the topn records to SCR would be a lot faster. Malcolm
Remember, if it wasn't for electricity, we'd be surfing the net by candlelight.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top