Page heading -- sql server reporting services

Nav
2/14/2006 11:55:32 AM

hi
I am tring to place a heading in page header dynamicaly. For e.g, I have
placed it as =ReportItems!member_name.Value as a text item. And the output
should be displayed as 'Department of Health' (if member_name is 'Department
of Health') as page heading. But I am getting the output as #error.
Query running behind has a Field name 'member_name' and data has been loaded
into it properly.
Can anyone of you let me know how to overcome this problem?

Nagini Indugula
2/14/2006 1:18:28 PM

Try this -
=First(Fields!member_name.Value,"DatasetName")

where DataSetName is name of the dataset where you have the query. In the
header, you can only have group functions like first,count,Max,Sum..I think
First would be most appropriate in your case.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Page heading