![]() |
|
|
#1
|
|||
|
|||
|
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.
Product AMay Jun Jul Product B Product C Product AAug Sep Oct Product B Product C Product ANov Dec Jan Product B Product C Product AFeb Mar Apr Product B Product C |
|
#2
|
|||
|
|||
|
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. |
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
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 |