cross tab group count ?????

[k1234]

Hi Everyone,

 

I have a report includes a crosstab, in crosstab i use 1 row group.

So, my need is to show the group count , i have 10  groups

 

(i did order by group_name in my query) .

 

for ex :

S.No.               Group_Name

1                       G1

2                       G2

 

up to S.No 10 and Group_Name G10.

 

How i could i achieve this in cross tab?

Any help would be greatly appreciated.

 

Thanks in advance.