Specific Column and Row Crosstab

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

Hi I am designing this New Report which needs to show a
specific Intersect between Row and Coolumn Heading:

e.g.

City_CD P_code Dept_A Dept_B Dept_C Dept_D
1 1 174 1168 4182 15607
1 2 35 177 588 2616
1 3 71 296 838 2261
1 4 32 90 241 655
1 5 16 31 69 146
1 6 111 732 2177 4324

My Query that i using in this scenario give me the above
result set. Now i am grouping on the City Code but i
want to show on the page like this :

Page Header/Grouping=City_Cd
But than i would like the Report to be Like this:

City_CD P_Code(3) P_Code(4)
Dept_A 71 32
Dept_B 296 90
Dept_C 838 241
Dept_D 2261 655


How can show Report like this ? How can Take Column
Headings from Table/Query and Make them like above on my
Report.
Please help me.
Thanks,

Sam
 
Try using a Transform and Pivot. You may have to CAT the
City_CD and P_code to accomplish (but maybe not). Post the
original query and I'll show you the modification needed.
 
Back
Top