can Any SSRS Geek reslove this issue ?

Question

can Any SSRS Geek reslove this issue ?

chauhanparixit

SSC-Addicted

Points: 429
More actions
June 13, 2011 at 4:23 am

#239057

HI Reporting Geeks
Is it possible to have an editable dropdown list parameter in SSRS?
i.e. User should be able to type in the value inside the dropdown paramter loist in addition to the normal 'select from list' operation....
I mean if my report have a list parameter EmployeeID , once user clicks on this list, user can find its EmployeeID and Click on View Report Button to view His/Her report. But it the list is Big, User wants to type his/Her employeeID in the same parameter.
(I have to use SSRS only)
Can you please share your thoughts to accomplish this task ?
Thanks in Advance!!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

You should be able to build some kind of association between EmployeeID and the windows user id and use the SSRS built in field UserID

Phil Parkin SSC Guru Points: 246960 More actions · Answer 2

Or provide an additional parameter and use a sp as the report's source to handle the selection in any way you wish ...

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

chauhanparixit SSC-Addicted Points: 429 More actions · Answer 3

@UDP Broadcaster

first of all : Thanks for the reply.

Hey i am not looking for any default login or anything like that..

let me give you a scenario

I have a drop down parameter Named Employee ID, I have 20 values in this , User can select any value out of it and Hit 'View Report' button and will get the associated report.

But i have slight different scenario, Now i have 1000 values in the same parameter and User have to scroll and find its Employee ID , My task is , User can type his/her employee id and user dont need to scroll and search for his/her employee ID Because the list of that parameter is 1000 and scrolling is not good idea here.

So I need a parameter which allow user to select value out if it by clicking one of the value and If user dont find it easily , User should be able to find associated employee id by typing in the parameter.

phonetictalk Hall of Fame Points: 3582 More actions · Answer 4

I don't know how to do that specifically, but could you have 2 parameters (1 that is populated via a drop-down, and one that is a plain text box) - so the user can either type in the text box or select from the list. Your report would then look to see whichever parameter is NULL and pass the other one to your stored procedure.

(When you modify your dataset, you can go to the Parameters tab and write an expression to map report parameters to the stored procedure parameters).

It's not elegant, I will admit.

Leonard
Madison, WI

chauhanparixit SSC-Addicted Points: 429 More actions · Answer 5

@LM1,

Thanks for the reply, I have a limitetion of One parameter only. One of the blog have provided a hint,

that take your SELECT statement in Default value and make that parameter Multi Velued parameter. But keep the data type as Text,

well i have tried that , now i can be able to type in drop down menu But it is not searching for me ?? nether showing associated report ??