Hi All,
I am using Visual Studio 2005 report desingner and SQL 2005. I have created one matrix report, but i want to insert the column total and row total.
or atleast column total
How do i do that ?
COLUMN1 COLUMN2 COLUMN3
qty amt qty amt qty amt
XXXX 2 11.00 3 22.00 34 23.50
YYYYY 3 22.00 5 27.00 35 33.50
How to do the colunm total.
Regards
Saleem
Assuming you have dynamic column and row groups, you can just right-click on the group and select "Subtotal" from the context menu.
See also: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rscreate/htm/rcr_creating_structure_objects_v1_7vi0.asp (scroll to the bottom section of "Adding Subtotals")
-- Robert
