Page header can't bind to a DataSet, what can I do?

[Audrey See]

My report page header contains a lot dynamic information. I would like to
create a table and bind many of its fields to a DataSet. But data fields are
not allowed in Page Header. Why?
The workaround I can think of is to use report parameters. I don't feel very
comfortable of passing too much information through parameters in URL
because there is the size limitation of URL.
Any one have any suggestions?
Thanks a lot.

[Daniel Kim [MSFT]]

Hello Audrey
One thing you can do is put a textbox in the page header and then get the
value of a textbox in the body using ReportItems.

For example
Say you have textbox named txtBody in the report body, you can drop a
textbox in the Page Header with the value

=ReportItems!txtBody.Value

to get the value

--
---
Daniel Kim [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
---

"Audrey See" <anni...@hotmail.com> wrote in message
news:OtSoFRTM...@tk2msftngp13.phx.gbl...

[Audrey See]

That's a great solution.
Thank you very much, Daniel.

"Daniel Kim [MSFT]" <dan...@microsoft.com> wrote in message
news:uBOqStTM...@TK2MSFTNGP12.phx.gbl...

[Audrey See]

Hi, Daniel:

This approach does not work out well for me.
I need the header to repeat on every page. Using the approach
you suggested here, I only get the values on the first page of the report.
From page 2, it is all blank.
Do you have any other suggestions?
Thanks.

"Daniel Kim [MSFT]" <dan...@microsoft.com> wrote in message
news:uBOqStTM...@TK2MSFTNGP12.phx.gbl...

[Rob Jones]

I had the same problem, the only way around it seems to be the have the text in a repeating section (i.e. repeat group header on each page).

Rob

----- Audrey See wrote: -----

[Ken Weeks]

Audrey,

Just as Daniel suggested will work. To have it show up on each page,
the textbox that is linked to the data will need to be placed in a
repeating section such as a group header like Rob suggested. If you
are using separate regions for each page, just add a hidden textbox for
each region (page), and concatenate the values in the page header
(since they'll all be null other than one).

At first, I thought this was a bug, but it is a feature. The reason it
was designed in this manner is when a user has to do page-level
aggregates. i.e. =Sum(ReportItems!SalesAmtTxtBox.Value) For this to
work, refernces to textboxes must only be allowed to "see" the
textboxes on the page. The way that you are using the textbox
reference feature is as a workaround for something else entirely: The
fact that we can't currently refer directly to fields in the page
header/footer. Chris Hayes from MSFT has indicated that they are
hoping to fix this limitation in the next version (not the service
pack, but version 2).

--

Kenneth Weeks

"One of the most important skills to build is the ability to hear your
wheels spin as you sink deeper into the muck." ~ Kirk Halgren

[Audrey See]

Thanks, Ken. I appreciate your detailed solution.

"Ken Weeks" <nos...@noisp.net> wrote in message
news:%237jI7id...@TK2MSFTNGP12.phx.gbl...

[George]

Hi

I have the same problem: by using this method, the header information
only shows in the first page, and it's all blank from page 2. Anyone
can help?

Thanks.
George

Rob Jones <anon...@discussions.microsoft.com> wrote in message news:<013B5198-2C36-4CFF...@microsoft.com>...

[Brian Welcker [MSFT]]

Can you put it in a table header (and set the table header to repeat)
instead of the page header?

--
Brian Welcker
Group Program Manager
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

"George" <wm...@hotmail.com> wrote in message
news:cbc2d49c.04052...@posting.google.com...