Report not displaying all of the data from 2 sub reports in Access 2010

Hello Crystal:

Thank you for replying.  Please view the link in my post. it explains the type of data I am trying to display.  Due to privacy concerns, I cannot share the actual sql.  but in a nutshell I have a report that is pulling information from an entry form.  This form has subforms on in that are bound to temporary tables in my db.  What I need to do is display this information in my report under the main section of the report.  This data is detailed information of products/services based on the subforms.  one tab on the subform have products, the other has services.  So in my report, I want to display the information separately first products (this a section header - just a label) and then the services.  So in my previous post, it was recommended to do two subreports one for each, which run successfully on their own.  The issue arise when I add these two subreports to my main report.  What is happening is part of the data is cut off at the bottom (where the detail,page footer, and report footer are located.  When I put these two sections in the detail section of the report, it renders all of the data correctly, however it creates a page for each of rows returned.  So if my products returned 6 records and my services returns 7, I will see a total of 13 pages with the same infomation.

I hope this explains what I am trying to do a bit better.  I can try to Unique value to true, however I do not want it to not display actual data that may have duplicate information.

Thanks,

Juan

Hello:

So I've set up unique value to be true, and it seems to work, however it is not showing my header information on the next pages.  Any thoughts on that?

Thanks!

Juan

on the Format tab of the Property Sheet for the group header, set Repeat Section to Yes

Thanks Crystal.  I figured that out by googling! LOL

Thanks for your help in steering me in the right direction.  Greatly appreciated!

you're welcome ~ happy to help