Results 1 to 8 of 8
  1. #1
    Join Date
    May 2004
    Posts
    5

    Unanswered: Getting Duplicating Report Pages

    Hi, I really need help with a report I am designing and was wondering if anyone may be able to help me out. I have a report that pulls from a query that holds data for an entire year. The query produces 12 lines, one summary line for each month. I have built subreports for each month and brought all 12 into the report. When running the overall summary report, the 1st page is exactly what I want with each month's individual data displayed under each applicable column. However, I also get 11 duplicating pages. I know that I have 12 lines of data from the query the overall report pulls from, but each are for a specific month and each has it's own subreport. I have no idea why I am getting 12 pages of the same report, so I would greatly appreciate any help I could get. Thank you so much.

  2. #2
    Join Date
    May 2004
    Posts
    5
    Can anyone lend a hand?

  3. #3
    Join Date
    May 2004
    Posts
    5

    Red face

    ..........

  4. #4
    Join Date
    May 2004
    Posts
    16
    Hard to tell, but my guess is that your RecordSource for the main report is the query with 12 records. Hence, whatever the report does, it is going to do 12 times. That is, the RecordSource for each subreport is only picking up the record of interest e.g., May, but it does it 12 times because the main report has 12 records to work on. If you put a text box on your main report with the ID or Month of the underlying record, my guess is that you will see "Jan", "Feb", etc. Having 12 subreports is probably the source of the problem, but at this stage it may be easier to change the RecordSource of the main report so that there is only 1 record, e.g. a fake, because you are probably ignoring it anyway.

    Sorry if I make an incorrect assumption.

  5. #5
    Join Date
    Oct 2008
    Posts
    3
    Don,
    I have the same issue. I have a report which is fed by a query (query1) and a sub-query (query2). I set up the report with the record source being query1.
    Is there another way to get by this issue without changing the record source?


    thanks!

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Don D looks kinda inactive tbh... which is normal when you post in a topic that is over 4 years old.

    Perhaps you could elaborate on what the problem really is. The more clearly the problem is explained the easier it is for others to help you.

    At this point, I don't know what the problem is... duplicate pages, extra blank pages, with something to do with record source.... not real clear.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  7. #7
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Same as Don D - For those issues where the main report is duplicated 12 times, what I've done is make it so the Main Report UNIQUELY only shows the fields it needs to show (i.e. IDField) and hopefully no other fields are needed which duplicate the recordset.

    I then join each of the subreports on the IDField.
    Last edited by pkstormy; 10-23-08 at 22:32.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  8. #8
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    You shouldn't need 12 subreports. If each month has a detail line in the main report with its top-level summary, there should also be a control with the month's name. Your subreport should refer to this control to limit its own output, and then you'll only need one subreport, used once in the design of the report.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •