Results 1 to 3 of 3
  1. #1
    cbrsix is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    214

    Report Design

    Hi, I am trying to create a report that looks similar in nature to the attached document. I can't figure out what is the best approach to this. Below are details about my db.

    - I want these grouped by by Rep name (as in the example) and then all relevant info populating based on info entered to their respective tables.



    - I have a separate table for each of these sections in the report that are linked by a common rep number which is associated with just one rep.

    I have been searching around and some people say to do subreports in the main report, but is that the best and/or easiest way to get to the end goal? Or would this be done better in another microsoft program?

    Thanks.
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    I think an Access report is as easy as it gets. I understand Crystal Reports can interface with Access db but never used it.

    When you want data from several child tables that are in a 1(or many)-to-many relationship, subreports is the best, perhaps only, approach. If the tables are all 1-to-1 relationship then subreports probably not needed.

    Use report grouping & sorting features to organize the records by rep.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    cbrsix is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    214
    Thanks. Subreports is the direction I'm going in. I just wasn't sure of other preferrable methods that have been tried before.

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

Similar Threads

  1. Format of Report Design
    By coolpal9 in forum Reports
    Replies: 1
    Last Post: 02-07-2012, 01:17 PM
  2. Replies: 3
    Last Post: 10-13-2011, 08:40 AM
  3. 07 Report Design; Grrrrr
    By cassidym in forum Database Design
    Replies: 3
    Last Post: 08-09-2010, 06:48 AM
  4. Replies: 3
    Last Post: 07-19-2010, 09:16 AM
  5. Pie Chart Design for Report
    By maggioant in forum Reports
    Replies: 0
    Last Post: 10-13-2009, 03:06 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