Hi frd's I hav one problem plz help....I hav to prepare a report I m using CR8.5
My DB :- SALE_TRANSACTION(DOC_NO,STORE_CD,SNO<ITEM_CD,EMP_CD,STATE_NM,DIVISION_NM,REGION_NM,TERRTIORY_NM,QTY,AMT)
Now I hav a group by on STATE_NM,DIVISION_NM,REGION_NM,TERRTIORY_NM,ITEM_CD.

Now the problem is my user want tht report should be free form If suppose he wants to view Report at Region Level so in tht my pg break shld be on REGION_NM i.e

STATE_NM,DIVISION_NM,REGION_NM and sum of all the  ITEM falls in the TERRITORY of the REGION_NM with the SUBTOTAL at REGION_NM level only no other totals.

Now same report he can view at DIVISION_NM level at tht time in a particular DIVISION_NM all REGION all ITEM details should come with subtotoal of only DIVISION_NM..


Wht I want to know is it possible if I provide user with a interface to select tht at which level he wants to view report thn accordingly I will show the report i.e if he wants to see at territory level thn sutotal of tht territory only will appear on the rpt no other leve total,similarly if he wants to view at region level thn subtotal will come for region only in tht case it wont be  like tht first all territory total will come and thn its region total.