I have a table having the following structure:-
Sr No.
Description
Application Description
Hrs
Month_Tot
Plan_1
Plan_2
In the crosstab I want the output as below :-
SR | DESCRIPTION | APPLICATION | APPLICATION |APPLICATION |MONTHLY | PLAN 1 | PLAN 2 |
NO | | DESCRIPTION 1| DESCRIPTION 2 |DESCRIPTION ... |TOTAL |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------
In other words in crosstab defination
Rows => Sr No., Description
Columns => Application Description
Values => Hrs.
I AM NOT ABLE TO PRINT THE MONTH_TOT, PLAN_1 & PLAN_2 FIGURES.
THESE COLUMNS SHOULD BE PRINTED AT THE END OF APPLICATION DESCRIPTION.
THESE COLUMNS ARE NOT TOTALS OF INDIVIDUAL APPLICATIONS BUT ARE COMPUTED FIGURES AND STORED IN THE TABLE UNDER RESPRECTIVE COLUMNS & hence I can not use CROSSTAB Functions. like sum etc.
Can anybody help me to resolve this problem.
Regards,
Raj
IIS (ARTS Team)
Telephone : 829 0635 Ext. : 1050
