I agree with Roland, the logic makes no sense and have no idea what you are trying to do. Seems like very poor table design to me.

As GilaMonster states, in this subsquery it is returning more than one row which cannot happen, please show us the whole query or find a way through correlated subqueries or...

Oh good I finally got a point this week. A few tough questions this week.

You need a dataset for each parameter. a piece of code that populates the parameter list. You could also use cascade parameters - meaning, if you choose a state,...

Don't know how I got this right, but definately need to know more about this topic, thanks.

try this: select DATEADD(dd,-14,CONVERT(datetime,CONVERT(nvarchar(11),GETDATE())))

Hard to say with the little information here, but it seems like you need to look at your layout for your other objects. And look at page brakes for...

Sounds simple enough: here are a few articles to read. Just include the parameters in your other dataset code.

http://technet.microsoft.com/en-US/library/aa337498(v=SQL.105).aspx

http://msdn.microsoft.com/en-us/library/dd255197.aspx

http://www.resultdata.com/adding-cascading-parameters-to-a-ssrs-report/

Google search on...

Also, if you are looking to dates to start at 12:00:00 AM, for the times you will need to use the convert and cast date/time styles. Ex. select CONVERT(varchar(10),DATEADD(MM,-1,GETDATE()-DATEPART(dd,GETDATE())+1),101)

Give this a try: https://www.katieandemil.com/t-sql-first-day-of-previous-month?tab=article

put these in variables:

SELECT DATEADD(m,-1, Dateadd(d,1-DATEPART(d,getdate()),GETDATE()))

SELECT DATEADD(m,-2, Dateadd(d,1-DATEPART(d,getdate()),GETDATE()))

SELECT DATEADD(m,-3, Dateadd(d,1-DATEPART(d,getdate()),GETDATE()))

SELECT DATEADD(m,-1, GETDATE())

SELECT DATEADD(m,-2, GETDATE())

SELECT DATEADD(m,-3, GETDATE())

You have to go to the developer and have them change the code in the underlying report. That tab is from a table or matrix of some sort and...

Check your sql dataset query for 'Exclude Value'. If that query results list changes all the time then that is the issue. I have seen this many times...

I better have gotten that one right, that is my job.

Nope, does not work.....

Got my coffee and took my time reading the question and the documentation. Patience and learning paid off, learned somthing, great question.