Results 1 to 3 of 3
  1. #1
    Steven19 is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2020
    Location
    London
    Posts
    110

    Report Design Help Required

    Hello all.

    I have a Report I need to design, but need advice on how to get it to work to my expectations.

    So I need a main report.

    This will gather information from one set of tables, it will include details such as the company etc.
    Then I need a sub report. This report will have the details of all the current directors of the company.


    Then I need a second sub report which will have specific company registrations.

    Layout is easy.

    Just the issue I have is that when I run the report after initially designing it, The First Sub Report, will replicate duplicate reports based on the number of directors for the company, so if I have one Director, I get a good report showing, company, Director, and Company Registrations.

    However if I have 2 Directors, I get Company Details, Directors Details for the first and second director and the Company Registrations, excellent, but then I get a copy of that same report.

    I have tried grouping the Primary Key for the Directors and Keep Together to see if that works, but it does not, so I need advice on things to consider and design ideas with regards to building a better database.

    I can not send a copy of the database because it is presently a database in use, and is over 10MB just on the front end.

    Questions/ Suggestions much appreciated for what I should consider, look for to remove this duplication issue.

    Regards

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the subreports do link on CoID.
    set the query of the report , set the property to UNIQUE VALUES = true, to not get duplicates.

  3. #3
    Steven19 is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jun 2020
    Location
    London
    Posts
    110
    So I had a look back on the control sources of the reports and found that. The control source for the main report was asking virtually the same as a sub report, so I re-designed the query to remove the issue.

    Thanks for your feedback. If you had not mentioned setting values to unique I would have spent an age looking for a needle in a haystack.

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

Similar Threads

  1. Report required
    By Riaz in forum Reports
    Replies: 5
    Last Post: 10-05-2018, 04:18 PM
  2. Report - Crosstabe query specific date report required
    By Kiran Prakash in forum Reports
    Replies: 1
    Last Post: 08-28-2018, 10:27 PM
  3. Table Design Help Required...
    By rd.prasanna in forum Access
    Replies: 11
    Last Post: 08-19-2013, 11:16 PM
  4. Access Database Design Expert Required ASAP!
    By devweb in forum Database Design
    Replies: 1
    Last Post: 06-06-2013, 06:33 AM
  5. Assistance on DB Design required - please
    By Optimus_1 in forum Database Design
    Replies: 13
    Last Post: 07-05-2010, 04:38 PM

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