Solved

Select a specified month

Posted on 2010-11-30
1
197 Views
Last Modified: 2012-06-27
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

0
Comment
Question by:Davesm
1 Comment
 
LVL 18

Accepted Solution

by:
x-men earned 500 total points
ID: 34238161
Create a new parameter Month on the report (@month) with the 12 possible values.

configure the dataset :

Select ...
From ...
Where QueryMonth in (@month)
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now