Solved

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

Posted on 2016-11-21
6
28 Views
Last Modified: 2016-11-22
I had this question after viewing How to create multiple groups on Access report.

I have the 2 subreports added to my main report.  When I run my main report, not all of the data in my subreports display.  For some reason, the information is getting cut off if it reaches the next section.  So my page has an unused Report Header, a page Header and detail section.  I've placed all of the data in thge page header section.  I tried to put it in the detail section, but then it generated a page for each row of data.

Does anyone know how to make the report expand to include all of the data in my subreports?
BTW: I have the Default View set to Print Preview, so that the end user can print the report.  The two options I have for this is Print Preview and Report View.
0
Comment
Question by:Juan Ocasio
  • 3
  • 3
6 Comments
 
LVL 19

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 500 total points
ID: 41896693
> "I tried to put it in the detail section, but then it generated a page for each row of data."

to eliminate duplicates in the Detail section, click in the RecordSource property for the subreport on the property sheet, and then on the builder ( ...) button. Turn on properties for the SQL/Query. Set Unique Values = true. Make sure there isn't an AutoNumber or something else on the grid that will cause duplicates anyway.  Without knowing what you are doing, I am just guessing.

The reason for not using the Detail section is usually to just show aggregated values.  Could you please explain what kind of data you have, what the goal is, and paste the SQL statement for the report?

> "So my page has an unused Report Header, a page Header and detail section"
be sure to close the space they take by clicking and dragging the bottom boundary of each section up when the cursor shape changes to a horizontal line with double-headed vertical arrow.
0
 
LVL 14

Author Comment

by:Juan Ocasio
ID: 41896766
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
0
 
LVL 14

Author Comment

by:Juan Ocasio
ID: 41897512
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
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 19
ID: 41897528
on the Format tab of the Property Sheet for the group header, set Repeat Section to Yes
0
 
LVL 14

Author Comment

by:Juan Ocasio
ID: 41897535
Thanks Crystal.  I figured that out by googling! LOL

Thanks for your help in steering me in the right direction.  Greatly appreciated!
0
 
LVL 19
ID: 41897565
you're welcome ~ happy to help
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now