I was asked to create a report to show the number of representative in each region of each state. I thought the easy way to do this would be to create a crosstab report State by region. They came back to me and asked if I could place the State above the Region column and hide the State column. I have attempted the Box equal none on the State field but will shift the data because the header column is merged and I cannot figure out how to unmerge that column. I have displayed how I have the report now and what they are looking for. Any help would be appreciated.
Store Representative 1996 1997 1998 1999 Average
"
Alabama" Alabama 15 16 16 14 15
Region A 7 7 7 5 7
Region B 4 5 5 5 5
Region C 4 4 4 4 4
"
California" California 4 4 4 5 4
Region A 1 1 1 2 1
Region B 2 2 2 2 2
Region C 1 1 1 1 1
"
Georgia" Georgia 7 9 10 10 9
Region A 4 5 5 5 5
Region B 2 2 3 3 3
Region C 1 2 2 2 2
"
Louisiana" Louisiana 8 9 9 10 9
Region A 4 5 5 6 5
Region C 4 4 4 4 4
Store Representative 1996 1997 1998 1999 Average
Alabama 15 16 16 14 15
Region A 7 7 7 5 7
Region B 4 5 5 5 5
Region C 4 4 4 4 4
California 4 4 4 5 4
Region A 1 1 1 2 1
Region B 2 2 2 2 2
Region C 1 1 1 1 1
Georgia 7 9 10 10 9
Region A 4 5 5 5 5
Region B 2 2 3 3 3
Region C 1 2 2 2 2
Louisiana 8 9 9 10 9
Region A 4 5 5 6 5
Region C 4 4 4 4 4
Hi,
you mean you have created crosstab Report with nested rows:
---------------------------
| State | State |
| |-------------|
| | Region |
----------------------------
and the Problem is that State now appears twice ? If so, then simply unlock the Report and delete the text in the first State box. The box itself is needed.
But this way you have a first blank column and a second column with State and Region.