Solved Is there a way to add multiple detail tabs to one report?

[fmcconaughy]

Hello all,

The title says most of it, I'd like to know if there is a way to add multiple detail tabs to one report and have them separated by headers?
I would like to have three sets of data on one report, each separated by a header.
Is this possible or do I have to create separate reports for each dataset
The data will be aggregated into one query.

as an example of what I would like

- Report Header
- Page Header
- Detail - dataset 1
- Page Footer
- Page Header
- Detail - dataset 2
- Page Footer
- Page Header
- Detail - dataset 3
- Page Footer

Thank you all!

 

[Pat Hartman]

Is this possible or do I have to create separate reports for each dataset

Each report is bound to a SINGLE recordset. The normal way to do this would be to create a main report with the high level grouping and then three subreports. One for each set of data. You can Stack them and use page break commands to get each to print on a new page if you want.

 

[fmcconaughy]

Each report is bound to a SINGLE recordset. The normal way to do this would be to create a main report with the high level grouping and then three subreports. One for each set of data. You can Stack them and use page break commands to get each to print on a new page if you want.

Ah completely forgot about subreports, I will look into that now thank you.

 

[DHookom]

It looks like you think you want multiple page headers/footers. Subreport don’t have a concept of pages so you might need to substitute group or report sections.

 

[mike60smart]

Can you upload a zipped copy of the database so we can see your tables structures?

 

[fmcconaughy]

I was able to achieve the results I was looking for using subreports Thank you. I achieved the header and footer structure by including headers and footers in the subreports. Thank you all for helping!

 

[Pat Hartman]

You're welcome. Frequently the solution becomes trivial once you are pointed in the right direction Happy New Year.