Anyone else having an issue when attempting to view a report with multiple dependent parameters?
Steps to reproduce the issue:
- Create a report with two or more parameters that do not allow blank or null values where the available values are pulled from a dataset.
- At least one of the datasets used to populate a parameter is dependent on the selection of the previous parameter (SQL statement has WHERE value = @Parameter)
- Create a table to display the data on the report.
- Click on the Preview tab.
- Select the parameters.
- Click View Report.
The report does not display.
If the parameters are altered to use default values, previewing the report does work.
Visual Studio: 16.11.6 SQL Server Data Tools 16.0.6211.27130 SQL Server Reporting Services 15.0.19528.0