CODEWITHSUNDEEP
reporting-servicesssrs-2012
SSMSJ
SSMSJ

Reputation: 219

SSRS Dynamic Date Parameters

I'm fairly new to reporting and need help with the following?

I have a report that has two date parameters statically set to default to the last financial year. i.e. the FROM parameter 01/04/2015 and the TO parameter 31/03/2016. When the actual date next year is 01/04/2017 I need these parameters to change forward by one year, I know I maybe able to do it with a case statement and a getdate + dateadd .

Upvotes: 0

Views: 352

Answers (1)

Neil Norris
Neil Norris

Reputation: 411

I have a small table which creates a year period based on certain dates which I then join onto the data then I use that to filter.

for instance:

1516 1617 1718

so if @year_period = 1516 then the previous year would simply be @year_period-101 and the future would be @year_period+101

Upvotes: 0

Related Questions