The sum of all SQL Server matter that exist,
and the space in which all SQL Server events
occur or could occur.
Welcome to SQL Server Universe.com Sign in | Join | Help
Home SS SLUG Forums Articles Photos Downloads
SQL Server Universe.com » SQL Server Components » SQL Server Reporting Services » Re: SSRS - Pass database parameter to page header & footer

Re: SSRS - Pass database parameter to page header & footer

  •  08-17-2007, 5:33

    Re: SSRS - Pass database parameter to page header & footer

    Reply Quote
    There are two ways of showing a value from one of your datasets in the page header textbox.

    One way is, if the field has already been added to the data region (table), find the name of the textbox (get the properties of the textbox and see the name property) and refer it in the page header textbox by using ReportIems collection. For example, if a field called “Name” has been added to the detail row of the table region and the textbox that has been used to hold it is “textbox1”, you can type a expression like =ReportItems!textbox1.value in the page header textbox.

    Second method is, add a report parameter for the report. In order to add a report, right-click on the background area of the report layout and click on the menu item “Report Parameters”. Add a new parameter by giving a proper name. Mark it as “Hidden”. Select “Non-queried” for “Available Values”. Select “From query” for “Default values”. Select correct dataset and field. Save it. Then in the expression of the page header textbox, access the parameter by using parameter collection. You may write something like =Parameters!Report_Parameter_0.Value.

    Hope this will solve your problem.
    Filed under: ,
View Complete Thread

(Best viewed with a resolution of more than 1024 * 768)
Powered by Community Server, by Telligent Systems