SSRS Report Header – Display Report Criteria

Some reports can require the proper headers and footers to let readers know the selection criteria and the date the report was written. You can learn how to supply the parameters that have been chosen to generate the report, in this post.

Once a text box has been placed, right-click it, choose expression, and then type the following expressions. Change your parameter names accordingly.

To Display the Selected Parameters
=”The report criteria selected is – ” &
“Start Date: ” & Parameters!StartDate.Value &
“End Date: ” & Parameters!EndDate.Value

To Display when the report is generated
=”Report Generation Date: ” & FORMAT(Cdate(today), “dd-MM-yyyy”)

Hope this helps.