forum.venkateswarlu.net
      Register      Login
Dropdown list In SSRS reports

1 replies to this topic

Kalyan Suman #1
Member
150 Points
Posted on 25 Nov 2014 07:18 PM IST

Hi All ,

I want to place dropdown list in ssrs report while passing parameters any one can guide me please

Thanks
Kalyan  Suman

 
SSRS     809 views     Reply to this topic
Kalyan Suman #2
Member
150 Points
Replied on 03 Dec 2014 01:17 PM IST

I got Solution for this

Steps:

Goto Dataset--> Parameters --> Ricghtclick Properties->window will apper--> choose available values --> select radio button as Get values from query then fill the appropriate one

then choose default values from window --> choose get value from query radio button fill all details then click ok aautomatically Dropdown will occours

write inside query as follows Eg am mentioning

Eg-1 Select Id,name from Employee [Emp] as a dataset name

Eg-2 select Id,Name,salary,Age from Employee where Name In [@EMP]

 
Reply to this topic