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

[meryls]

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

 

[synapsevampire]

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