SQLTeam.com | Weblogs | Forums

Creating a new parameter in SSRS



Hello all,

I need some help adding a new parameter that will accept a date Range of current, 3 months, and 6 months. I have a current data set and I am using a embedded data source. Within the Date Range parameter the returned report must start at the 1st of the month and end today. Will I need to add the parameter to the Query or just a reference to the new parameter?

=DATEADD(mm, -3, DATEADD(mm, DATEDIFF(mm, 0, Today()),0)) as FirstdayofThreeMonthDateRange

Is there a better way of doing this? and has anyone had to deal with fiscal year parameters?


You can not give the reference, only you can add the parameters in query.

It may help yours https://www.mssqltips.com/sqlservertip/3421/add-a-date-range-dataset-in-sql-server-reporting-services/