Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    6

    Unanswered: reports & subreports

    Question:

    I have a badly designed database but, here is what I need to do. I need to return the results of 3 tables

    table1
    table2
    table3

    For a given work order table2 may have 2 records and table3 may have 3 records. Can I use a report that will pass the result set to two subreports? For example I may have filtering criteria on the main report that would tell it to only include data for work orders 1, 2 and 3. I want the 1st subreport to return the lines for labor for those work orders and I want the 2nd subreport to return the parts that were used for those work orders.

    Is there a way to do this?

    Thanks for your help:-)

  2. #2
    Join Date
    Nov 2003
    Location
    Netherlands
    Posts
    85
    Make a report on table3
    make a report on table2 and add the report you made on table3 as subreport. Link both of them

  3. #3
    Join Date
    Nov 2003
    Posts
    6

    Smile

    Thanks I had done that and it did work


    Originally posted by lodewijk
    Make a report on table3
    make a report on table2 and add the report you made on table3 as subreport. Link both of them

Posting Permissions

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