My report has a parameter of "End_Date" which is used to create my dataset from a stored procedure. In the dataset, a column called "Begin_Date" is returned with various other information used in the report creation.
Currently, the parameter "End_Date" is used in the page header as part of my report title. My user's whould also like to see the "Begin_Date" value in the page header.
Both End and Begin dates are unique values occuring once per report run. How do I get the "Begin_Date" contained in my dataset as a value to be displayed in the page header title?
many thanks
The current method is to add a hidden text box to the body with that value. Then reference that text box value in the page header.
In future releases we are looking at adding field references to the other page sections.
|||Thank you Brad for the response. Please excuse my lack of understanding. In the Page header, any time I reference a field in the body I get a message basically saying "Fields can not be used in any page headers or footers".
I have tried placing a hidden text box in the body with the value and referencing it in the page header, but with no success. I continue to receive the "Fields can not be used in any page headers or footers" error message.
Have I misunderstood your response? thanks
|||you need to give reference like these for the header textbox
=ReportItems!txtReportHeader.Value
where txtReportHeader is the text box in the body, which contains the value of the dataset field
|||Thanks rakam, it worked like a charm....
I didn't realize you could reference ReportItems from headers and footers. Appreciate the information.
No comments:
Post a Comment