sql server reporting services: Dataset Query Parameter -- sql server reporting services

Dataset Query Parameter

Todd Simmons
6/10/2005 8:06:04 AM

sql server reporting services:

I have a dataset query that contains the expression:

Cost * (1 - ABS(SIGN(DATEPART(mm, OrderDate) - DATEPART(mm,
DATEADD(DateInterval.Month, - 11, { fn NOW() })))))

I have had no luck replacing the { fn NOW() } with a parameter and was
wondering if it was at all possible.

RE: Dataset Query Parameter

Harolds
6/10/2005 12:16:04 PM

To use parameters in a dataset query expression, use @ParameterName.

[quoted text, click to view]

RE: Dataset Query Parameter

Todd Simmons
6/13/2005 5:59:05 AM

I tried that and get a "Syntax error or access violation"

[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.