Results 1 to 2 of 2
  1. #1
    fabiobarreto10 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    169

    Problems wich subreports

    Gentlemen,




    I have a table "company" with a one to many relationship with the table "Product". The table "Product" has
    a ratio of one to many tables with the "Steps" and "Notes." I have a report with three subreports,
    (1. With the product name and company. 2. Steps and 3. The comments.) In each
    one of the master field is the "ProductID" field and also the son "ProductID". After choosing a product shows a button
    clicking it opens the report in accordance with the chosen products. (picture1).


    I'm trying to choose a company that when open the same report with all products. But that the steps become
    and the separate observations, like the image that I built. (picture2)


    Thanks for helping.
    Attached Files Attached Files

  2. #2
    fabiobarreto10 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    169
    Friends, I am sending the db again with some modifications to better explain. Please open the form (fFilters) in combo
    Analyst choose "David" and then in the combo "Company" choose "IBM", will show a button labeled "Briefing"
    click it to open a report with 5 subreports, according to the chosen company. I'm trying to get out of each product
    separately, as in the model Doc.

    Thank you.
    Attached Files Attached Files

Please reply to this thread with any new information or opinions.

Similar Threads

  1. subreports
    By emerrube in forum Access
    Replies: 2
    Last Post: 08-24-2011, 07:35 AM
  2. Subreports - Different
    By frousseau in forum Reports
    Replies: 1
    Last Post: 09-07-2010, 05:14 PM
  3. Using Subreports
    By jonesy29847 in forum Access
    Replies: 5
    Last Post: 04-20-2010, 11:16 AM
  4. Replies: 5
    Last Post: 04-01-2010, 03:48 PM
  5. Hiding subreports
    By aouellette in forum Reports
    Replies: 0
    Last Post: 09-12-2008, 08:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums