Checking Parameters

[xxing]

Hi I have a report that has two parameters

@StartDate @EndDate

You enter the dates then the report executes a stored procedure.

Is it possible to do some checking on the parameters before the stored procedure is executed. e.g. Check if the @StartDate is greater then the @EndDate? I want to do the checking in the report not in the stored procedure.

Thank you

 

[xlbo]

why do you want to check in the report as opposed to the stored proc?

FWIW, I think the only way you could do this feasibly would be to make the end date dependant on the start date and use a list of dates that are generated by a query using the start date as criteria. Other than that, there is no kind of validation in RS parameters

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question