Using parameters to manipulate data sets -- sql server reporting services

Karl
2/28/2006 11:55:28 AM

I am trying to do some date manipulation in the data set based on a report
parameter . The parameter is called RDate and is a datetime type.

DATEADD(DateInterval.month, DATEDIFF(DateInterval.month, RenewalDate,
@RDate), Month)

When I "run" the dataset, I get this message: "Syntax error or access
violation"

When I replace @RDate with a "real" date like 1/1/2000 it runs fine. I have
tried a variety of things to get around this but am striking out including
casting the parameter as date time and using a declare/set statement. I can
filter just fine using the parameter as a critera.

Any ideas what might be causing this?

K.

daw
2/28/2006 2:56:27 PM

Try using a stored procedure instead.

[quoted text, click to view]

Bruce L-C [MVP]
2/28/2006 5:04:00 PM

Try defining the parameter as date/time. Report Menu->Report Parameters

Is this part of the where clause?

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[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 about sql server reporting services

sql server reporting services : Using parameters to manipulate data sets