sql server reporting services: filtering on a dataset -- sql server reporting services

RE: filtering on a dataset

Andre
7/18/2005 7:02:05 AM

Kerrie,
If you do it on the dataset using SQL then:

WHERE mydate > dateadd(mm,-12,getdate())

Andre

[quoted text, click to view]

RE: filtering on a dataset

Andre
7/18/2005 7:39:07 AM

Do the results look correct if you run the following query:

SELECT [Current Date] = getdate(),
[12 months back] = dateadd(mm,-12,getdate())

If not then maybe the server time is incorrect.

Andre

[quoted text, click to view]

RE: filtering on a dataset

Andre
7/18/2005 8:16:03 AM

Do you get any results when you run the query? Are you using MSSQL Server?

[quoted text, click to view]

filtering on a dataset

Kerrie S via SQLMonster.com
7/18/2005 1:32:22 PM

Hi all!

I am trying to filter a dataset. Could someone help me?

I only need the last 12 months from the system date.

systemDate.field< 12 Months

Anyone have any suggestins?

Thanks in advance,
Kerrie

--

RE: filtering on a dataset

Kerrie S via SQLMonster.com
7/18/2005 2:25:06 PM

That does give me results but it is giving me the same results as if that
statement was not there.

[quoted text, click to view]

--

RE: filtering on a dataset

Kerrie S via SQLMonster.com
7/18/2005 3:09:45 PM

I am working with a frozen database. It still is not liking that. I thank you
for your help though.

[quoted text, click to view]

--

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.