Remove merged cells on the header line

[Dano75]

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   

[colt]

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.