report (using the wizard) with 8 queries

[fabiobarreto10]

Friends, I made a report (using the wizard) with 6 fields in a query. It works perfectly.
How do I make a report (using the wizard) with 8 queries, all with 6 fields?
But the view was separated in the report.
Thank you.

[pbaldy]

If you want them separated, you're looking at using subreports based on each query.

[fabiobarreto10]

Hey Paul, thank you.
I'm selecting all queries in the wizard. how do I separate each query in the report, but they all stay in one report. Sorry, it was unclear to me what you said.


Thank you.

[pbaldy]

A report can only have one source query. One option would be a UNION query that joined all the others into 1, but you said you wanted them viewed separately. That leaves you with subreports. Create a report based on 1 of the queries. Create another report based on another. Then start a new report, and use the subreport control to add each of the other reports you created to this new one as subreports. The subreport control is one of the buttons on the ribbon along with text boxes, etc.

[fabiobarreto10]

ok, I'll try.Thank you.

[fabiobarreto10]

Paul, I did as you told me. It worked partially. I'm not able to make the header of thesubreport is displayed on the Main Report, Main Report and also in some reports were"tight", "together", and the data were in half. I did so, for each sub I used five lines and left a space of a line between the subreports. The images may explain better.
Thank you.

[pbaldy]

Page headers will not show when a report is a subreport. Try putting those in the report header.

[fabiobarreto10]

Paul I put the header in the main report, but it was not good because it was only "up" and not in each subreport.
It is impossible to put the header on each subreport? Thank you.

[pbaldy]

You can use the subreport's report header, just not its page header.

[fabiobarreto10]

Sorry, but how do I?

[fabiobarreto10]

How simple it was. I just took out the page header of the subreport, and put the heading of the
subreport. Only the data with each page has a blank page. how do I get this blank page?
Thank you.

[fabiobarreto10]

Paul, I did it! Thank you. Just dragged the white part of the report.
Thank you.

[pbaldy]

Sorry, been grinding on a big project. Glad you got it sorted out!