month parameter between

Hi Dhananjay Rele,

Per my understanding that you have two parameters "Start Date" and "End Date", when the "start date" is bigger then the "End Date", there will be no data in the report, right?

This is by design, gernerally the Start Date should not be bigger then the End date and if the user have select it bigger then the End Date, we can give an alert message to let him know and reselect the values.

Details information below for your reference about how to add this alert message to warn the user.

1. Select the whole tablix and in the Tablix properties, add an expression in the No Row Message as below:
   
   
   
   Expression as below:
   
   =IIF(Parameters!StartDate.Value >Parameters!EndDate.Value,"StartDate can't be bigger then the End date, please select the correct values","No Record between the date range")


2. Preview you will see result as below when you have select the wrong parameters:
   
   

If you still have any problem, please feel fre to ask.

Regards

Vicky Liu