Microsoft Access Forums

Go Back   Microsoft Access Forums > Access Forums > Access

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-18-2010, 12:51 PM
HRhodes HRhodes is offline Windows XP Access 2002 (version 10.0)
Novice
 
Join Date: Jan 2010
Posts: 1
HRhodes is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 01-18-2010, 05:01 PM
llkhoutx llkhoutx is offline Windows Vista Access 2007 (version 12.0)
Expert
 
Join Date: Jan 2010
Location: Houston, Texas USA
Posts: 340
llkhoutx is on a distinguished road
Default

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.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sums in Detail area of report Rick West Reports 2 12-01-2009 04:15 PM
The section width is greater than the page width? Gary_Marshall Reports 2 11-13-2009 10:54 AM
report detail duplication archie Reports 5 09-17-2009 06:51 PM
Space Between Header and Detail in Report tigers Reports 3 06-22-2009 10:01 PM
Report Detail Entry Selection Problem Joe Reports 0 02-02-2009 03:55 PM


All times are GMT -8. The time now is 10:25 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.