Drop down list with user entry
Hi i have parameter drop down box in my report with few values. I now want to give my users the facility to either chose one of the values or enter their own customised value. Will someone please throw some light on how to achieve this? (N.B. - Just to also point out that in another one of my report I have a multi-value parameter whcih needs user entry as well but I am assuming if the above can be sorted then this one can too) Thanks alot
April 27th, 2011 6:18am

hi usama Very easy in Report data Field expand parameters and right click on parameters want to list drop down and go to parameters properties and give values in available value field can also assign default values on clicking on default values. in available values cick on add button first give diplay value and next give value of parameters with will go to data base. hope will work fine for you.
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2011 7:58am

Hi ericcisci Thank for the reply but I do not think my question was clear enough. I already have my list of available values but let me describe a bit more. What I now wanted was: Once the report is run, the user can open the drop down list and select any one of the values from there --->> OR the USER could if he wanted also TYPE in a value
April 27th, 2011 8:31am

Hi ericcisci Thank for the reply but I do not think my question was clear enough. I already have my list of available values but let me describe a bit more. What I now wanted was: Once the report is run, the user can open the drop down list and select any one of the values from there --->> OR the USER could if he wanted also TYPE in a value
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2011 8:31am

Hi getusama, Generally, in the “Available Values” page of the “Report Parameter Properties” dialog, we can choose the available values for the parameter. If we select the option “Specify values” or “Get values from a query”, after previewed the report, there will be a drop-down list for selection of parameter value. Only select the option “None” that support for user input values in the parameter textbox. Based on your requirements, one workaround is to use two parameters, one is used as a textbox and the other is used as a drop-down list for selecting. For example, if we filter data in the report level, we can use an expression to decide which parameter value is used to filter report data. For example, I have three fields in my dataset which are Category, Year and OrderQuantity, I want to filter my report data depends on the category. In order to achieve to this, please refer to the steps below: 1. Add a parameter to the report, input “InputCategory” in both “Name” and “Prompt” properties, and then select “Allow null value” checkbox. Click OK to close the dialog. 2. Add another parameter to the report, and input “SelectCategory” in both “Name” and “Prompt” properties. Then, specify available values in the “Available Values” page, 3. Add a “Filter” in the dataset to filter report data. Set the filter like this: Expression: [Category] Operator: = Value: =IIF(IsNothing(Parameters!InputCategory.Value),Parameters!SelectCategory.Value, Parameters!InputCategory.Value) (This expression is used to decide which parameter value is used to filter data) When preview the report, if we select the “Null” checkbox, we can select the value in the drop-down list of the “SelectCategory” parameter to filter the report data; if we not select the “Null” checkbox, we can get the value which is input in the “InputCategory” parameter textbox to filter report data. If you have any question, please feel free to ask. Regards, Bin Long
April 29th, 2011 4:52am

Hi Sorna Thanks for the reply. I was afraid it will not be possiible. I have used exactly the same kind of idea as you have prosed already but it seems that my client is not happy with that. I have already told him that it was not possible and he can only have either one (fixed list of values OR user input) in the same box.
Free Windows Admin Tool Kit Click here and download it now
May 3rd, 2011 4:56am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics