I have a report parameter which depends on a query from the Dataset. The query needs one parameter and sql server reporting has no parameter drop down
version – Microsoft SQL Server 2016 Report Builder
Best Answer
Dataset parameters are not defined there.
To define the "value" of the parameter, you have to edit the dataset itself. That's where you will specify what value you want your query to run with; you can use a static value, or a report parameter.
If you use a report parameter as the value for your dataset, the dataset will not execute until the report parameter value is defined by the user. This will make the report behave like, "the values of parameter 2 only become available after selecting parameter 1".
Simple solution... posting for anyone else testing SQL 2016.
Do NOT supply a default SSRS Server URL during the installation process and it completes without error (Windows 2012 Datacenter and Windows 7 confirmed).
After a lot of digging around, I didn’t get anywhere, then eventually I got Microsoft involved to help me with the problem.
MS solution architect confirmed that the Report Builder requires a direct connection to SQL Server when launched hence the working with data sets in the report builder failed. Apparently this is BY DESIGN and it is not going to change.
This was in SQL Server 2008 R2 but the same is true for SQL Server 2012, 2014 and 2016. Not sure about 2017 but I doubt it very much if that has changed in 2017.
We ended up providing the client a machine on the network in DMZ to which end users connected remotely, only to work with the Report builder, it is a poor solution but it worked at that time and we needed a quick fix for it at that time.
Best Answer
Dataset parameters are not defined there.
To define the "value" of the parameter, you have to edit the dataset itself. That's where you will specify what value you want your query to run with; you can use a static value, or a report parameter.
If you use a report parameter as the value for your dataset, the dataset will not execute until the report parameter value is defined by the user. This will make the report behave like, "the values of parameter 2 only become available after selecting parameter 1".
Hope it helps.