Select a specified month

Hi I need to be able to select a specified month from the attached script when i put it in Reporting services. Please note that the are may rows with the same month in as this is the querymonth that the query was logged

I am not sure if i need to use a delcare date or how to put a where clause in so the user can chose a month
Select	QueryYear
		,QueryMonth
		,QueryMonth_No
		,BusinessDays
		,RealDays
		,employmentstatus
		,Region_Name
		,BusinessChannel
		,measure
		,ApplicationType_Name
		,QueryType_Name
		,QueryStatus_Name
		,QueryLevel1
		,querylevel2
		,querylevel3
		,Volume
From dbo.Query_Management_Dashboard

Open in new window

DavesmAsked:
Who is Participating?
 
x-menIT super heroCommented:
Create a new parameter Month on the report (@month) with the 12 possible values.

configure the dataset :

Select ...
From ...
Where QueryMonth in (@month)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.