Multiple reports into one

[evenflow58]

I suppose I'm probably looking for a resource rather than a straight answer as I don't think this is a quick fix but anything that can get me on the right path would be helpful. I have created a form template that I send a SQL query to show a list of statistics based on a date and shift number query. What I'm trying to do now is create is combine those forms together into one large form. Basically it would look like this:

Stats for all
<Page break>
Stats for 1st shift
<Page break>
Stats for 2nd shift
<Page break>
etc

I've uploaded the report to try and clarify what I am referring to but it does not work because it relies on an external call to create the SQL statement and is only the basic stat report template.

I was hoping I could use the original form template I created and basically just copy it however many times for the shifts I need. I thought this might be easy to do with subreports or grouping but I'm not sure how to go about iterating the creation of each report. Any advice would be helpful.

 

[scalextric59]

Are ypu talking about a form or a report? because in your 1st paragraph you say "form". If it is a report you need to use the Sorting and Grouping option for the report and group by shift.

 

[George_E]

That is what I am trying to do aswell. I have 3 independant reports, each with their individual queries, but at one point I need to combine all 3 into one large report, does anybody know how to do that?