horizontal show query result

sandeepBha

hi all,

I have to show data in my report table like below

school name KG 1 2 3 4 5 6 7 8 9 10 11 12

DPS delhi 23 45 65 62 86 49 58 72 56 83 91 58 47


but query fetched data like this

school name class avg
DPS delhi KG 23
DPS delhi 1 45
DPS delhi 2 65
DPS delhi 3 62
DPS delhi 4 86
DPS delhi 5 49
DPS delhi 6 58
DPS delhi 7 72
DPS delhi 8 56
DPS delhi 9 83
DPS delhi 10 91
DPS delhi 11 58
DPS delhi 12 47


so how can i do this.
Please tell me soon its so urgent.

thanks in advance!!!!!!!

sandeep

mwilliams

Hi sandeep,

A crosstab should work perfectly for this. School and name as row dimensions, class as the column dimension, and avg as the measure. Let me know if you have questions.