Results 1 to 3 of 3

Thread: Sub Report Loop

  1. #1
    Join Date
    Sep 2004
    Posts
    3

    Unanswered: Sub Report Loop



    I have nested sub reports in Access that are looping when I run the report. It acts like it's printing a full report for each line item (200 line items, 200 reports). The hierarchy of the report is as follows.....

    MAIN REPORT DETAIL
    SUB REPORT DETAIL
    SUB REPORT DETAIL

    What is causing this looping, and how can I stop it?

    Thanks,
    Lance

  2. #2
    Join Date
    Jun 2004
    Location
    Terrapin Nation
    Posts
    205
    Run the underlying query to see if you get the detail records you expected. Bet you dont.

  3. #3
    Join Date
    Sep 2004
    Posts
    3

    Post

    Thanks for the reply. All queries and reports return the expected values, but when I nest them into subreports they loop.

Posting Permissions

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