Using parameters to manipulate data sets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Karl - 28 Feb 2006 19:55 GMT

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.

Reply to this Message

daw - 28 Feb 2006 22:56 GMT

Try using a stored procedure instead.

> 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.
[quoted text clipped - 13 lines]
>
> K.

Reply to this Message

Bruce L-C [MVP] - 28 Feb 2006 23:04 GMT

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

Is this part of the where clause?

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Try using a stored procedure instead.
>
[quoted text clipped - 19 lines]
>>
>> K.

Reply to this Message