Can total be moved to top of column rather than bottom

Standard newbie disclaimer: I have searched the archives and this is
my second week with the tool, so my apologies if this is a rather
simple question or I am not asking the question properly.
My team has received a specification for a report where the customers
would like to see column totals at the top of the column, rather than
SSRS's default of bottom. I am new to banded report writing, so I am
hoping this is fairly simple. Using BusinessObjects, I would have
inserted a row at the top of the column and then copied the formula
from the total (or subtotal) line up to the line I had just inserted
(then deleted the row at the bottom).
Is there similar functionality with SRSS?
Kind regards,
Steve HaffnerYes, it is possible.
Option-1: If you want to show the total besides the group name: Ask them to
add the group Header(if not available). besides the group name table cell ,
write a expression like =sum(field!columnname.value)
Option-2: If you want to show the total in top of the group name:
right click on table row(Group row) and click on insert row above. and write
a expression like ="Group Total : " & sum(field!columnname.value)
Regards,
Sriman.
"shaffner" wrote:
> Standard newbie disclaimer: I have searched the archives and this is
> my second week with the tool, so my apologies if this is a rather
> simple question or I am not asking the question properly.
> My team has received a specification for a report where the customers
> would like to see column totals at the top of the column, rather than
> SSRS's default of bottom. I am new to banded report writing, so I am
> hoping this is fairly simple. Using BusinessObjects, I would have
> inserted a row at the top of the column and then copied the formula
> from the total (or subtotal) line up to the line I had just inserted
> (then deleted the row at the bottom).
> Is there similar functionality with SRSS?
> Kind regards,
> Steve Haffner
>|||On Apr 5, 10:48 am, "shaffner" <steve_haff...@.hotmail.com> wrote:
> Standard newbie disclaimer: I have searched the archives and this is
> my second week with the tool, so my apologies if this is a rather
> simple question or I am not asking the question properly.
> My team has received a specification for a report where the customers
> would like to see column totals at the top of the column, rather than
> SSRS's default of bottom. I am new to banded report writing, so I am
> hoping this is fairly simple. Using BusinessObjects, I would have
> inserted a row at the top of the column and then copied the formula
> from the total (or subtotal) line up to the line I had just inserted
> (then deleted the row at the bottom).
> Is there similar functionality with SRSS?
> Kind regards,
> Steve Haffner
This can be done similarly in SSRS. You can either insert a row/group
in the top of a table control and add something like the following as
the expression:
=Sum(Fields!FieldName.Value)
Also, you can do the totaling in the stored procedure/query that is
sourcing the report and just pass it to the report and create a
textbox control at the top of the table control and include it there.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant