SSRS Dates Parameter Validation Using Custom Code

Question

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

or

with the

 

@AdmitDate

@DischargeDate.

 

 Please, any suggestions are welcome.

 

Thanks.