Monday, February 20, 2012

Reporting services: Anchor.Bottom

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,
PieterHi,
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.
Ignacio Machin
http://www.laceupsolutions.com
Mobile & warehouse Solutions.
"Pieter" <pieterNOSPAMcoucke@.hotmail.com> wrote in message
news:Ot5Uo5bNIHA.5140@.TK2MSFTNGP05.phx.gbl...
> 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
>|||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
"Ignacio Machin ( .NET/ C# MVP )" <machin TA laceupsolutions.com> schreef in
bericht news:%23SC9Z9bNIHA.4196@.TK2MSFTNGP04.phx.gbl...
> 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.
>
> --
> Ignacio Machin
> http://www.laceupsolutions.com
> Mobile & warehouse Solutions.
> "Pieter" <pieterNOSPAMcoucke@.hotmail.com> wrote in message
> news:Ot5Uo5bNIHA.5140@.TK2MSFTNGP05.phx.gbl...
>> 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
>|||Thank you both Michel and Ignacio for your reaction, but unfortunately this
doesn't help me at all :-(
Wat I need is a way to stick something to the BOTTOM of the final page. With
your proposals it will indeed come at the end of the report, but not at the
bottom of the last page...
Anybody any idea?
Thansk a lot in advance,
Pieter
PS: About the other newsgroups: Sorry for posting it to multiple newsgroups,
but because it has soemthing to do with both languages I posted it in there
too :-) My apolgizes :-) Personally I don't midn cross posting, as long it
is one and the same post, and not 4 times the same messages.

No comments:

Post a Comment