sql server reporting services: Using Parameter Values on Page Header -- sql server reporting services

Using Parameter Values on Page Header

Damon Allison
12/15/2004 4:05:42 PM

sql server reporting services:

Hello All:

I've been reading through previous posts regarding the inability to display
field data in the page header for all pages on a report.

The posts pointed me to create a textbox in the header and set the text box
value to:

=Parameters!<myparam>.Value

Is this the easiest way to display data on each page's header? What I now
need to do is figure out how to set a parameter to a field value our
resultset. For example, we get a resultsetset like the following:

Firstname LastName Address
Damon Allison 1234 first street

I'd like to display these values on the header for each page's report.

PS. This feels like a really common need - to display data on each page's
header. Why is this so hard? It feels like a total hack.

Damon

Re: Using Parameter Values on Page Header

Wayne Snyder
2/3/2005 8:50:37 AM

Have you tried simply adding a textbox to the group ( but make it large
because it will be the header ) and use
=First(Fields!.Firstname.Value)

If you page break on a group , this will give you the first item in the
group ... It is often used as a kind of page index where you can display the
first and last item on the page..

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

[quoted text, click to view]