I am using parameters PeriodType where depending on what will choose will set Dates for DateFrom, DateTo parameters like in the following example:
Period Type (DateFrom, DateTo)
- Yesterday - 06/24/2019 - 06/24/2019
- Today - 06/25/2019 - 06/25/2019
- ThisWeek - 06/24/2019 - 06/30/2019
- LastWeek - 06/17/2019 - 06/23/2019
- ThisMonth - 06/01/2019 - 06/30/2019
- Range - Manually will pick dates from DateFrom and DateTo
When I select for example "This Month" period, DateFrom and DateTo receive dates and Report displays the results. Result of the selected period When I select "FromTo" period, my dataset query which generates dates returns null (tried even to return nothing from the procedure) and Date Parameters remain empty and contain calendar icon for choosing dates manually. If I select the dates and run the report, nothing happens and date parameters become blank. Blank DateFrom and DateTo
Default Values for DateFrom and DateTo is set the same as available values. I even tried to set to No default value but the issue remains the same.
What can I do in this case?