Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS 2016 - cannot see parameter

I am self-learning SSRS via Microsoft SQL Server Data Tools, VS 2015. I am using tutorial from here

I cannot see the parameter I created in preview. The visible has been selected in parameter properties. What have I missed out? Thanks in advance if anyone can help me.

. Microsoft SQL Server Data Tools, VS 2015

. Microsoft SQL Server management studio 2016

Design enter image description here

Preview enter image description here

Parameter Properties enter image description here

like image 887
DiscoDude Avatar asked Jul 10 '16 12:07

DiscoDude


People also ask

How do I add a parameter in report Builder?

To add or edit a report parameter In Report Builder or Report Designer in SQL Server Data Tools (SSDT), in the Report Data pane, right-click the Parameters node and click Add Parameter. The Report Parameter Properties dialog box opens. In Name, type the name of the parameter or accept the default name.


1 Answers

SSDT/Visual studio is strange and strange glitches such as this occur quite often. Another similar glitch is when changing the dataset sql query, sometimes you will have to delete reportname.rdl.data in the project folder for the changes to occur.

Saving and reopening is the only guaranteed way to fix your problem.

like image 75
Azuraith Avatar answered Sep 26 '22 14:09

Azuraith