473,788 Members | 2,861 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Report/subreport/subreport repeating problem

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.

If I print the 2nd by itself then it does not repeat any data.

So the problem is with the 1st subreport link to the 2nd. If there is
only one detail record for the 2nd, then that prints fine. But if
there are 4 detail records, then the detail gets repeated 4 times.

Let me know if you need more information. Thanks for any help or
advice.
Mar 27 '08 #1
0 2363

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3306
by: Roger | last post by:
I couldn't find anything at http://www.mvps.org/access/reports/index.html I have a report with static (name, address, etc) in its report header and a subreport in the report's detail section the subreport has column headings in both its report and page headers (until I figure out which is best) when I print the report, the subreport headings show on the first
4
2808
by: Trevor Best | last post by:
I have a report that's fairly simple, page headers and footers, detail has a subreport in (can vary in length). The customer wanted a signature block for them, their client and 3rd party. This was no problem, couple of boxes and labels in the report footer. Now customer wants this signature block on the foot of page 1 (stoopid IMO as that implies people read page 1 where at the end implies they read past page 1 at least). Anyway to...
3
7405
by: lorirobn | last post by:
Hello, I have a report which uses a subreport. When I run the report, I get "Enter Parameter Value" error message for "tblGuestRoom". I click ok and the report seems to work fine. I narrowed down this error to the Link Master Fields property setting, when I tried the same scenario with form/subform. It gave me error: 'The Link Master fields property setting has produced this error: The object doesn't contain the Automation object...
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...
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. ...
12
8036
D Giles
by: D Giles | last post by:
Access 2003: A subreport control (sum total calculated textbox located in the subreport report footer) does not show total of all records when referenced as a total in the main report footer - only shows one record amount. When I open the subreport alone, it totals the sum of all the records which the query pulls - which is what I want. The referenced textbox in the main report footer only shows one record amount. Why is the total in the main...
5
934
by: Paulson | last post by:
Dear friends I am working on a windows application and I am using crystal reports in that.I have a table Country and another table State in the database.I want to show the report as follows. Country(TableName) State(TableName) India TN AP ...
2
19430
by: jmartmem | last post by:
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...
0
10364
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
10172
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
9967
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
7517
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
6750
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
5398
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
5536
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4069
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3670
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.