• In SSRS you cannot specifiy optional parameters in this way.

    You can allow nulls in all 3 parameters. and then the user has to know what to put in or not.

    Or you can add a dropdown parameter that has values, Effective Date, Start Date.

    and 2 date fields. With the second date field allowing nulls.

    Pass the Drop down Parameter to your code to figure out what to do with the dates passed in.