DROPDOWN LIST
-
HI all,
Anyone know how to do the folowing using report parameter
I have a parameter dropdown (using contain) in a report which gets its data from the cube using the the paramater set here.
I want to be able to use the "contain" filter so that when the user starts typing it will filter as they enter - for example
I want to filter the dropdown to find "I am here"
Currently when I enter "I" it takes the dropdown to the start of "I" and does not let me continue typing "am" and finish typing "here" thus I would only have "I am here" in the list
is this possible?
If not does anyone know how to filter a dropdown based on free text entered into a dropdown?
-
Not possible out of the box with SSRS. To have the 'intellisense' or 'auto-complete' style functionality in a DDL you need like javascript or equivalent, where the current text being entered is bounced to the server and the contents of the control are dynamically updated. These do exist out there, but it would mean wrappering your report access with another app (e.g. a asp.net front end).
Steve.
-
Thanks for your response - thats what I feared !
Do you or anyone know how to add textbox parameter before the dropdown which a user can enter the text in and use this to filter the dropdown based on what has been entered
-
It *should* be as easy as creating a new parameter and then cascading it's contents to the second parm (the one which has a DDL).
Being a little more specific, you will already have a query that is used to populate the DDL contents. In this query, add a new parm, you'll want to use a function such as LIKE (TSQL) or FILTER (MDX). Adding the new parm to the existing query will add this as a parameter to the report. Go to the parameters section (where this is depends on whether you're using 2k8 or 2k5), and ensure that the new parameter is higher in the list than the existing. Being earlier in the list means it will be presented earlier to the user. It also allows the second /subsequent parameter to use it's contents.
HTH,
Steve.
-
Thanks again - do you or anyone know if this is possible as an alternative....
1. Add a Parameter to allow user to enter free text to search called filter
2. Add another parameter called operator with values such as equals,like, begins with - after this to allow the user to select what type of filter they want to use to filter the dropdown
Then the third parameter being the dropdown has the result of the text entered and filtered by the operator selected.
I think I am mostly there - just getting confused to where I place the conditions - this is what I have done..
data coming from a cube with the paramater for the customers name set here as an =(equal)
then in RS
i have created 2 parameters
1. Filter - this has no values attached - free textbox to enter a value to search with
2. Operator which has the following added in available values under specified
LABEL VALUE
equal equal
like like
begins with begin
This is were I am getting lost how do I apply this to the dropdown to show the result?
where do I place the expression to filter based on the 2 previous parameters and how?
Any help would be great
🙂
-
Sounds like an OK approach. The only potentially tricky part will be in the usage of the parameters as you'd outlined. Basically it sounds like the final query (ie the one that returns data) will need to be text (e.g. ="select blah " +param.Value + ....) so you can string together the right operator with the input the user has made.
Steve.
-
Create a dataset to pull values from the cube with the query below.
select <parameter3 value that goes into the the dropdown> from cube where <parameter3> <param 2 like = begins with> <parameter2>
Now, the third parameter is filled with values defined by the search and filter conditions in parameter1 and parameter2.
Hope this is clear...
"Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply