Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2010
    Posts
    20

    Unanswered: reports and subreport filtering

    I have a report with a subreport on it. the subreport can have many records related to the report. I open the report with a wherecondition that limits the records on the main report to what i specify. the records on the subreport are also limited to the related records on the main report.
    so far so good. My Problem.
    if the sub report has more than 1 related record the main report will show a record for every record in the sub report.
    example:
    if vendor "A" has 3 products then the main report will show vendor "A" 3 times with the 3 products instead of showing vendor "A" one time on the report with the 3 products in the sub report. I duplicates the records.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    It sounds like the source of the main report is incorrect. It should be the table that contains the vendors. The subreport would be based on the table that contains the products. Can you clarify your table structure and what the reports are based on?
    Paul

  3. #3
    Join Date
    Feb 2010
    Posts
    20
    thanks for the reply. you were right, my source was not the table. I made the adjustment and everything works.

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Happy to help.
    Paul

Posting Permissions

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