After exporting SSRS report to excel, certain fields are having blank values

  • I tried to insert a field into the page header and I got the error...

    "The value expression for the textbox .... refers to a field. Fields

    cannot be used in page headers or footers."

    So I googled it and found a workaround. I used a hidden textbox in the body and referenced the value of the textbox in the header using ReportItems!xx.Value.

    But the problem that I am facing is while exporting the report to excel. The header part which I refered using ReportItems appears to be blank.

    Does anyone have the similiar problem?

    Any input will be appreciated.

  • I solved it by using hidden parameters.

    To do this, create a new data set that contains the values that you want to put in the report. In general, the query should only return a single row. After defining the data set, create a hidden parameter for each value you want to display. Set both of the available values and the default values for these parameter to the data set and field that contains the information that you want to show. Then you can simply add them to the page header or footer using the =Parameters!ParameterName.Value syntax.

    Refer to the link below.

    http://blogs.msdn.com/bwelcker/archive/2007/06/19/marquee-moon-field-references-in-page-headers-and-footers.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply