Date range validation -- sql server reporting services

jules_crown NO[at]SPAM hotmail.com
11/19/2004 2:35:56 PM

Hi,

forgive the newbee. I have a 'from' and a 'to' date input parameters
(nullable) used in the WHERE section of my query.

I can't find a way to make 'to' (when set) a dependency of 'from',
i.e. if the user chooses a 'from' date, the available values for 'to'
should be >= 'from'

Advice, anyone? Cheers,

Alien2_51
11/19/2004 3:49:03 PM

If you're talking about conditionally add the filter to your where clause,
something like this will work.

SELECT * FROM Table
WHERE
((@FromDate IS NULL) OR (@FromDate IS NOT NULL AND cs.DateSold >= @FromDate))
AND ((@ToDate IS NULL) OR (@ToDate IS NOT NULL AND cs.DateSold <= @ToDate))

[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 : Date range validation