I am developing a SSRS Report in which i have date parameters based on different selections. It has the date range like
1) Last week
4) Last quarter
So when user selects the last week, last month, last year my parameter works fine because i have given the pre-determined functions for date in my SQL code. And for custom date i have given null values. Please see the attached for code. But when the user selects custom date and picks date in start date and end date text boxes don't work and they throw out a error saying select a parameter, even after selecting the date range. Because i have given null in the sql code for custom date. In run time when i am passing the date string it is unable to understand.
For this reason i decided to create two extra text boxes for custom date and use them. When the user select the custom date the custom start date and end date should pop up dynamically and give the user access to select the date range from the calendar picker.
But even now the custom date text boxes are unable to understand the date passed as it had null in the back end for period selected.
Can anyone suggest any solution for this issue. And i am also looking to show the custom start date and custom end date text boxes only when user selects the custom date under Period drop down. Is it possible??
Please see the attachments for my sql code, Period screen shot, date text boxes, and error message.
Any help is appreciated. Thank you..