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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I repeatedly go throu the same recordset using a subreport?

Status
Not open for further replies.

meryls

Technical User
Nov 20, 2003
62
US
I feel like I should know how to do this, but I'm stumped.

Can I put a subreport into a main report that will run off the same recordset multiple times?

If I am passed a set of dates as a parameter to the main report, and a recordset from a VB program, can I then run the subreport once per each date in the range and have it process the whole recordset each time?

I'm using CR 9, VB6 and ttx files.

Thanks for the help!
Meryl
 
Consider that if you are passing multiple dates as parameters, it is MUCH more efficient to pull all of the dates back in a single recordset, and then let Crystal use a Group to report off of each set of date data.

A subreport would not be required. Passing a recordset from a VB prgram will also prove less efficient, the degree of which is dependent upon what is being queried.

At any rate, the parameter should be a multiple parameter or a range type, and then insert a group based on the date, and you'll have the equivalent look of numerous reports, yet with subtotals and grand totals available.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top