C
Cory Rammer via AccessMonster.com
I have a report that groups on 3 parameters. Obviously, the default
grouping structure on a report would be:
<Param01 category01>
<Param02 category01>
<Param03 category01>
<Param03 category02>
<Param02 category02>
<Param03 category01>
...
etc..
However, I would like the inner-most parameter to group vertically on the
page instead of horizontally, as in:
<Param01 category01>
<Param02 category01>
<Param03 category01> <Param03 category02>
<Param02 category02>
<Param03 category01> ...
etc..
To help make this more clear, Param01 in my case represents different
stores, Param02 represents different distribution areas, and Param03
represents different Customer Types (e.g. "Loyalist", "Lapse User", etc.)
The report breaks down the three parameters by calculating Fields such as
"Number of items ordered", "Average price of items ordered", "Average
discount applied to orders", etc.
I would like to report the Customer Types side-by-side on the report
instead of one underneath the previous.
I have attempted to manipulate the design cranked out by the Report Wizard
many different ways, but I think I may be on a bogus mission.
Any suggestions would be greatly appreciated. Thank you!
grouping structure on a report would be:
<Param01 category01>
<Param02 category01>
<Param03 category01>
<Param03 category02>
<Param02 category02>
<Param03 category01>
...
etc..
However, I would like the inner-most parameter to group vertically on the
page instead of horizontally, as in:
<Param01 category01>
<Param02 category01>
<Param03 category01> <Param03 category02>
<Param02 category02>
<Param03 category01> ...
etc..
To help make this more clear, Param01 in my case represents different
stores, Param02 represents different distribution areas, and Param03
represents different Customer Types (e.g. "Loyalist", "Lapse User", etc.)
The report breaks down the three parameters by calculating Fields such as
"Number of items ordered", "Average price of items ordered", "Average
discount applied to orders", etc.
I would like to report the Customer Types side-by-side on the report
instead of one underneath the previous.
I have attempted to manipulate the design cranked out by the Report Wizard
many different ways, but I think I may be on a bogus mission.
Any suggestions would be greatly appreciated. Thank you!