I am working on a report on SQL Server 2008 R2 and i have 2 date parameters. Start Date and End Date.
Every time when i want to see preview, i need to mention both Start Date and End date and i used to see the report.
I got a new requirement that i need to add another parameter 'Effective Date'. Adding a parameter is easy but here is the twist. The requirement is, if i mention the Effective Date (not mentioning Start Date and End Date) and click View Report i need to see the report. Usually when i did that, a pop up shows up that i need to select Start Date and End Date.
Do we have any way that we can mention either (Start Date and End Date) or Effective Date and vice versa.