Group summay in Sql report
-
hi friends, i have a report using matrix table something like.. Jan | Feb | Mar ----------------------------------------------- sale | s_qty | sale | s_qty | sale | s_qty ----------------------------------------------- Loc_A 10 | 20 | 10 | 15 | 20 | 50 11 | 16 | 30 | 15 | 20 | 20 10 | 20 | 05 | 10 | 50 | 10 ** Loc_B 15 | 30 | 40 | 45 | 10 | 60 14 | 16 | 30 | 15 | 20 | 20 19 | 20 | 05 | 10 | 50 | 10 ** Loc_C 10 | 20 | 10 | 15 | 20 | 50 11 | 16 | 30 | 15 | 20 | 20 10 | 20 | 05 | 10 | 50 | 10 Now whats my problem is i need the summary of each group.(showed in '**'). i used Matrix table , and now showing the grand Total also. but i need group summary. Can any one help me.. Thanks in advance...
-
hi friends, i have a report using matrix table something like.. Jan | Feb | Mar ----------------------------------------------- sale | s_qty | sale | s_qty | sale | s_qty ----------------------------------------------- Loc_A 10 | 20 | 10 | 15 | 20 | 50 11 | 16 | 30 | 15 | 20 | 20 10 | 20 | 05 | 10 | 50 | 10 ** Loc_B 15 | 30 | 40 | 45 | 10 | 60 14 | 16 | 30 | 15 | 20 | 20 19 | 20 | 05 | 10 | 50 | 10 ** Loc_C 10 | 20 | 10 | 15 | 20 | 50 11 | 16 | 30 | 15 | 20 | 20 10 | 20 | 05 | 10 | 50 | 10 Now whats my problem is i need the summary of each group.(showed in '**'). i used Matrix table , and now showing the grand Total also. but i need group summary. Can any one help me.. Thanks in advance...
-
You need to group by Loc_A,Loc_B and Loc_C ? Write result which you want to get.
I Love T-SQL Don't torture yourself,let the life to do it for you.
-
i used stored procdure for tat & i grouped in the report. the current result i'm getting is what i showed. but i need the group wise total...
-
Ok, now you need to get sum of columns sale,s_qty grouped by Loc_A,Loc_b and Loc_c? Are you usng Crystal Report to show data report?
I Love T-SQL Don't torture yourself,let the life to do it for you.