asked
add validations in ssrs
I have a ssrs report which have start date and end date as input fields. i need to throw a validation if end date is greater than start date. how to do it?
Put this at the start of your stored procedure: if @EndDate < @StartDate begin raiserror('EndDate cannot be earlier than StartDate.', 16,1); return; end The return will stop the procedure from continuing.
16 People are following this question.
