CODEWITHSUNDEEP
reporting-servicesssrs-2008reportingssrs-2008-r2
Sandy
Sandy

Reputation: 275

how to create a textbox in ssrs for user entry as a parameter

I have a report that has three params. one is dropdown. It created automatically when i supplied name and value, Then If we select multivalue, it shows multivalue dropdownlist.

But I am not able to create a textbox. That will act as a parameter to be supplied in report.

for that I have created a parameter, set it to allow null and datatype = "text" . parameter visibility is also visible but as a result I can see a textbox which is a disbled one.

How can this textbox be made to work?

Upvotes: 1

Views: 5101

Answers (2)

miniris
miniris

Reputation: 26

To allow user to enter the parameter value manually:

  1. Right click on the parameter and select Parameter Properties
  2. On the Available Values tab, select None
  3. Click OK

Now users can manually type in the parameter value.

Click to see screenshot

Upvotes: 0

R. Richards
R. Richards

Reputation: 25151

While in the Report Parameter Properties for the text field in question, chose Allow blank value (rather than Allow null value). In the Default Values section of the properties dialog, choose Specify values, Add a blank default value.

Now you will have a working text field that the end user can type into, and you can use that value for searches in your query.

Hope this helps

Upvotes: 2

Related Questions