SQLTeam.com | Weblogs | Forums

Creating a new parameter in SSRS

coding-standards
sql2012

#1

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?


#2

Hi,
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/