Search code examples
sql-serverreporting-servicesssrs-2008ssrs-2012

SSRS Page footer Date Range


How can I show date range for my SSRS report without passing the parameter? I run an invoice between 1/1/2018 to 7/30/2018 & I need to show this date range in the page footer.


Solution

  • If the report has actual parameters (populated by whatever means) you should be able to use in a text box in your footer.

    =Parameters!MinDate.Label & " " & Parameters!MaxDate.Label
    

    or

    =Parameters!MinDate.Value & " " & Parameters!MaxDate.Value