Is this grouping structure possible...?

  • Thread starter Thread starter Cory Rammer via AccessMonster.com
  • Start date Start date
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!
 
Cory said:
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.


Generally, this should be done by removing the param03 data
from the report's record source. Then create a multi-column
report for the param03 data and use that as a subreport.
 
Thanks for the reply, Marshall. Since I posted that I have decided to use
an Excel pivot table as the reporting structure even though I did not want
to introduce a middle-man application. If the pivot table idea needs to be
scrapped I will use your suggestion.

Thanks again,
Cory
 
Back
Top