SSRS Dates Parameter Validation Using Custom Code

Hi everyone.

Im trying to create an SSRS report that uses 4 parameters to imput the dates. I need to find a way to perfrom all the validations requested by the client.

I have 4 Dates.

@StartDate

@EndDate

@AdmitDate

@DischargeDate.

First, I need to do the basic validations to make sure that @StartDate<@EndDate

and @AdmitDate<@DischargeDate.

the next problem is, the user wants if they select an @StartDate, the @EndDate should not be null and the @AdmitDate and @DischargeDate should be desable.

the user can search using StartDate and EndDate or AdmitDate and DischargeDate

the last problem, I need to pass to my query some parameters to identify if the search is with the

@StartDate

@EndDate

with the

@AdmitDate

@DischargeDate.

Please, any suggestions are welcome.

Thanks.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
Parameter validation is front-end / business logic part and may not / will not be a reports job. Hope you are dealing with this in that layer only and not bringing it to SSRS.

No need to identify it in stored procedure with an additional parameter. Just check which one is null and you know which parameters are to be used.