Please give me reply soon........

["Srini ." <vasbrio@HOTMAIL.COM>]

Hi Friends,
I am new to this Users Group, i am happy to inform to you all.
I am Srinivas, working with Texas Department of Criminal
Justice,Huntsville/Tx. I have several questions on SQR Reports.

I have to create one report like this....
I have to display data like this ...
Statewise , Regionwise, Districtwise And Officerwise offenderslist.

First i have to display all offenderlists officerwise in all districts under
single region. Then under that dirsticts, i have to display region heading
and under all district details and under that i have to display state
heading and under all regions.
but i am getting district wise data only...........while i am printing
region and under all districts...i am not getting district details..
please give me the solution to get the data abouve format.

District name dist1
officername name1                   offenders 10
officername name2                      ''     20
officername name3....                ''        5

District name dist2
officername name1                   offenders 10
officername name2                      ''     10
officername name3....                ''        5
  .............

Region region1
dist1                         offender        35
dist2                          ,,             25
........

State state1
region1                   offenders 60
region2                      ''     80
region3                        ,,
.....

Please i need above format

Thanks
Srinivas

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com