• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1006
  • Last Modified:

SSRS - how can I allow the user to edit default parameter values at run time

I have a bunch of reports that I am converting from Crystal Reports to Reporting Services.  The only stumbling block I have is a report which has a report parameter in Crystal that has three default values and has a check box ticked for "Allow editing of default vaules when there is more than one value".  SSRS doesn't seem to have anything like this at all.

Can anyone assist, or advise of a good workaround.

Basically, the user would be presented with the three values in a drop down list but they can actually type in their own if they don't want one of the default values.

Many thanks,
Howie
screenshot-editingdefaultvalues.JPG
0
howie999
Asked:
howie999
  • 2
1 Solution
 
ValentinoVBI ConsultantCommented:
In SSRS, report parameters are always editable by the user.  Have a look at Lesson 2 & 3 here to get started with (multi-value) parameters: http://msdn.microsoft.com/en-us/library/aa337432.aspx

Let me know if you have any further questions on this.
0
 
howie999Author Commented:
Thanks for your reply.  I know that the user can make a selection from the multi-select drop down list.  IE, they can choose one or more values.  But I wanted them to be able to also type in their own value which this control doesn't let them do.  I have instead left the multi select but added a further text box so that the user can enter a further value there if they wish.  I think that's the best option.  Thanks for your help.
0
 
ValentinoVBI ConsultantCommented:
Ah, that's what you meant!  Well, as you have found out, combining the list of default values with free text input from the user is not possible through the same parameter.  A second parameter, as you have done, is probably the most interesting workaround in this case.

What I do want to add: isn't there any way to avoid the users entering their own values?  I always try to avoid that, too many typo issues and so on...  Perhaps a small config app can help here?
(just my thoughts though, I can understand that in your company it's not an issue because users are used to that way of reporting)

Best regards, Valentino.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now