How to run a Report Several times by passing in multiple variables

[kgreer]

I have a Crystal Report that I call from a ASP page. I want to pass it multiple Part numbers and make it print out a new report for each page. In the Report I am using three different sub-reports. First one is a Pick List, second is the order, third the router. For every part I want all three subreports to run, once it is done with the first one I want it to produce the same reports for the second one, etc...

If I need to explain more, please let me know.

Thanks.

 

[IdoMillet]

A simple approach is to pass the part numbers as a mult-value parameter, set the record selection fromula to ensure the report includes only these parts, group the report and start each part on a new page, and place the subreports in the group header.

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[kgreer]

Maybe I am not explaining my situation enough. The sp that I am calling is allowing only one part parameter at a time. All three of my subreports are in the header section. I want it to print out the first part number then move on to the next part. But I want all three subreports to run on part one then run again on part two and so on. If I need to send the report let me know.

Thanks for the input.

 

[IdoMillet]

Consider changing the SP to accept a delimited string of multiple part numbers...

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[kgreer]

I don't want to allow my sp to handle mult parts. I want to print one Pick list then print a bill of material, then my third sub-report. When it has reached the third sub-report with the first part I want it to take the second part and start over at the first sub-report. Am I not making any sense?

 

[IdoMillet]

You could use your asp code to call the report multiple times, passing a different part each time.

There is no way (that I'm aware of) to do this in a single call.

Again, if the report can contain and be grouped by these part numbers, the problem is solved. You simply embed the subreports in the Group Header and/or Footer.

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[kgreer]

Thanks for you input. I don't want to have to open a new page for every part number printed.

They will have to suffer.