hello experts,

      i need to generate a report in asp.The result is group by 2 fields
(say fr example).The output shld be presented as follows...

Group1 field
Group2 filed

fields3    field4    field4
*******    ******    ******
value      Value     Value
.....
....
.....

Group2 field

fields3    field4    field4
*******    ******    ******
value      Value     Value
.....
....
.....

is there any sql query which will make my presentation part easier.will 
SHAPE command in MSdatashape solve my purpose.

regards.
manohar.