Inserting a new row in Cross Tab....
I have a technical question regarding the limitation of CR 10.0. I will get the following dataset from Stored procedure. (Grant_Name, Class, Value). Possible values for Grant_Name are Paid,Star,Fed,General. Values for Class are New and Renewed. Value cab be any value.
My requirement is to show the data in a cross type kind of report. This will have Grant_Name on row level. Class and Value on Column level. And the summarized field will be Value. the lay out is some thing close to below...
(Please note that Sub-Total is the new row i'm looking to insert...which is a sum of Paid,Star and Fed....Can we tweak Cross Tab to insert a new row? Or do i need to use Sub Reports for the new row?
Paid 1 2
Star 5 3
Fed 7 32
SubTotal 13 37
General 10 12
TOTAL 23 49
If i use a cross tab with Grant_Name on Row, Order_Class & Value on Column with Value as summarized field , i'm not able to achieve the "SubTotal" row which is essentially a sum of (Paid,Star and Fed) values.... how can i achieve this using Cross Tab? Can we do this cross tab or DO i need to work with some other method? I'm out of ideas..is there any suggestion?
As an FYI... I just gave u a short part of report...the original report will also have Level_Indicator on row wise..It means that the above report model will be repeated for Level1, Level2 etc which is given by another field...I did not give those details as i thought it is not really needed....
Please give me any suggestion..