Reporting services: Anchor.Bottom

[Pieter]

Hi,

I have a report (Reporting Services 2005) which may contain an undefined
number of pages of records. At the end there are some totals and summary's
that should be displayed.

The problem is: These totals should come always at the bottom of the final
page: some kind of Anchor.Bottom or Docking.Bottom property, but this
behaviour doesn't seem to exist.

Is there any way to accomplish this?


Thansk a lot in advance, any help will be really appreciated,

Pieter

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

First of all do not cross post to groups ont related to your question, this
is a C# NG that has nothign to do with RS.

Answering your question, you can include a second table just below your main
table and display there the totals, This table will be displayed right after
your main table so you should be ok.

 

[Michel Posseth [MCP]]

Hello Pieter


Another solution is to use the Table footer

This is the way i do it and it seems to work fine here

Hint :

Open the toolbox in the report designer , drag and drop a table object on
the report

the table has standard a table header ( for the column describing text )
, table body wich contains the data from the dataset
and a table footer wich can be used to sumerize totals of certain columns

if you setup a data source , you can just drag and drop the columns in the
apropriate order , you might notice that the designer is that smart that it
actually creates
the table describing headers , column repeaters and sumerizing footers for
you !

Play a litle with it and you might conclude that the wizards only make you
look stupid , in my opinion you are much more flexible if you do everything
by hand and it is not even that much difficult.

Oh by the way i am a VB coder , maybe the C# guys are a litle upset because
the format scripting used in reporting services is a litle to much VB look
a like

Just kidding

i guess microsoft.public.dotnet.general and / or
microsoft.public.sqlserver.reportingsvcs were indeed more apropriate


HTH

Michel Posseth