473,772 Members | 2,292 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access report problem repeating detail section subreport

87 New Member
Greetings,

I have an Access report that contains a Page Header, Detail, Page Footer and Report Footer, My problem is that the subreport in the Detail section repeats over and over when I run the report. What I get is a final report which is 465 pages when it should be only three.

I'm sure there's something in the properties that's forcing the subreport to repeat over and over again but I can't figure out what it is.

Whatever help anyone can offer would be greatly appreciated.

JM
Jun 19 '08 #1
2 19428
PianoMan64
374 Recognized Expert Contributor
The reason that your subreport is repeating over and over again, is because you've placed in the detail section of your report. That section will fire for EACH record in the table that the main report is based on. If you want to have the subreport only so once, with the relative records below each main record in the report, then you need to make sure that the main and sub report are linked by some Linking ID so that it's not displaying the whole subreport for each record in the report.

Hope that helps,

If you want a more detailed answer, then you will need to provide more details as to how the two tables that the two reports are based on, are linked together, even if they aren't and what you're trying to get the report to do that it isn't doing now.

Joe P.
Jun 19 '08 #2
jmartmem
87 New Member
Thanks, Joe. I checked the properties and found the way I'd linked the main and sub reports was causing the problem. One small adjustment and the report is running as I'd expected.

Many thanks for the advice and support.

- JM
Jun 20 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
3529
by: Bill Short | last post by:
I have a subreport in the detail section of the main report. The subreport is set to CanGrow. I am using the Me.Line method (thanks to Stephen Lebans) to create vertical lines that fill in between bottom of the subreport and the top of the footer section. I have this code working with the one problem. When I open the detail section up to the size I need for the lines to touch the lines that begin at 0.0" of the footer section the report...
4
2606
by: Mark Reed | last post by:
Hi Guru's, Hopefully I can explain this OK.....What I am trying to do is create a QC check sheet using the following fields: ASN, PO & Qty. This information will be at the top of each report with loads of labels below which users will have as a check list. 1 ASN may have many PO's and the Qty is at PO level so 1 Qty for each PO I have set it up so far so that a new page is forced for each ASN. On each page there should be 1 ASN number,...
2
3236
by: jburris | last post by:
In my current database, I have a single table which contains order information such as product, unit price and payment. The payment for each product is entered in and subtotals and totals are calculated fields on reports. With this setup our customers pay for each product in full. I am trying to divide the table to move payment information to a related table such that customers can make partial or installment payments. I managed to...
3
2889
by: lesperancer | last post by:
I've got the following tables tblMaster masterID etc tblDetail masterId detailId etc
2
2546
by: jammer | last post by:
Hey All, I have a report based on a query that joins a 'parent' and 'child' table. Each row in the query corresponds to a row in the child table, with a few fields from the Parent table. At the bottom of the report, in the footer, I total some values from the Child table.
3
1845
by: Jimmy | last post by:
Is there a way to force access to wait a specified time before making a calculation? On my report there is a subreport with a number of calculation on it. One if which is a count of certain records using a text control with a running sum. When I display the subreport on my main report, I can see the correct count but when I make a reference to that control on the main report, I simply get the number 1. I am sure that the reference to the...
7
6475
by: baool | last post by:
I have a report that keeps track of sales by company for any given month within a year. I am using two subreports embedded within a report to produce 2006 (one subreport) and 2007 (the other subreport) sales by station for any month I choose. The report works but I have two issues: 1) The subreports are located in the detail section of the report. The report should be three pages long but the report keeps repeating the data for a total of...
2
1620
by: owyn999 | last post by:
Right so, I've got a report that I wrote a few months ago and just now we started using it. This report is a dynamic report coded mostly in Visual basic with all of the fields being can shrink and can grow true. The issue that I am having is that I have a section of the report which had to be a subreport, and while this shouldn't be an issue I think I have done something wrong in the creation of the subreport. ...
0
2363
by: EManning | last post by:
Using 2003. I've got a main report with a subreport and within that subreport is another subreport, all bound. The detail in the 2nd subreport is repeated multiple times for some reason. The main report prints a vendor name, the 1st subreport prints the budget # used to pay that vendor. The 2nd subreport prints the detail of those payments. If I remove the 2nd subreport, then the main and 1st subreport print just fine.
0
9454
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10264
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10106
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9914
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7461
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6716
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5355
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5484
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3610
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.