Results 1 to 2 of 2
  1. #1
    HRhodes is offline Novice
    Windows XP Access 2002
    Join Date
    Jan 2010
    Posts
    1

    Report Width....Stacked Detail?

    I have a report that needs to display 12 months of data with 4 columns for each month (48 columns across). This is too much to put going across the report even if it is landscaped. Is there a way to have 3 months across and then 3 more months across below it, etc. I have repetitive multiple row values for each month.



    May Jun Jul
    Product A
    Product B
    Product C
    Aug Sep Oct
    Product A
    Product B
    Product C
    Nov Dec Jan
    Product A
    Product B
    Product C

    Feb Mar Apr
    Product A
    Product B
    Product C

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Build you stack in a temporary table with multiple queries and a Qtr indicator, with product, monthly data appearing in the appropriate columns. Then group your data by quarter.

    The stacking will require numerous queries, but they will be lightning fast in the aggregate.

    A pass through Oracle query will do the stacking/grouping for you.

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

Similar Threads

  1. Sums in Detail area of report
    By Rick West in forum Reports
    Replies: 2
    Last Post: 12-01-2009, 07:15 PM
  2. The section width is greater than the page width?
    By Gary_Marshall in forum Reports
    Replies: 2
    Last Post: 11-13-2009, 01:54 PM
  3. report detail duplication
    By archie in forum Reports
    Replies: 5
    Last Post: 09-17-2009, 08:51 PM
  4. Space Between Header and Detail in Report
    By tigers in forum Reports
    Replies: 3
    Last Post: 06-23-2009, 12:01 AM
  5. Report Detail Entry Selection Problem
    By Joe in forum Reports
    Replies: 0
    Last Post: 02-02-2009, 06:55 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