Wednesday, March 21, 2012

Matrix report question

Hi,
I recently made a matrix report and I have a small problem with it.
I'm trying to add a row that contain the total of each column but I'm not
sure how to do that.
Do I need to do something at the query level or this can be done within the
report designer?
I'm using SQL 2005.
Thanks!
SimonOn Apr 18, 10:08 am, "Simon Renshaw" <s...@.benchmarkconsulting.com>
wrote:
> Hi,
> I recently made a matrix report and I have a small problem with it.
> I'm trying to add a row that contain the total of each column but I'm not
> sure how to do that.
> Do I need to do something at the query level or this can be done within the
> report designer?
> I'm using SQL 2005.
> Thanks!
> Simon
This link may be helpful:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/d3293edae89f51e8/c15839fd5fb7df14?lnk=st&q=matrix+report+subtotal&rnum=4#c15839fd5fb7df14
That said, I prefer to handle the subtotals/totals in the query/stored
procedure that sources the report (via a while loop or cursor). Hope
this is helpful.
Regards,
Enrique Martinez
Sr. Software Consultant|||Yes it is.
Thanks a lot!
Simon
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176921521.454724.47460@.l77g2000hsb.googlegroups.com...
> This link may be helpful:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/d3293edae89f51e8/c15839fd5fb7df14?lnk=st&q=matrix+report+subtotal&rnum=4#c15839fd5fb7df14
> That said, I prefer to handle the subtotals/totals in the query/stored
> procedure that sources the report (via a while loop or cursor). Hope
> this is helpful.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

No comments:

Post a Comment