1

I am trying to create a specific value in a SSRS parameter that is composed of multiple possible values.

Because in the back-end, each of these Label-value pairs can have multpile possible values.

I wanted to see if i could use a temp -table with those values hard-coded, but not sure how

enter image description here

Improve this question

1 Answer 1

Reset to default
3

Sounds to me like an XY-problem, and I would strongly suggest looking into the following two alternatives to the solution you're aiming for:

  • If those values (30, 35, 36, and 40) have a shared meaning, consider normalizing them in a table in your database, and having the value for SecurityDrops correspond to that group of values (e.g. through the foreign key).
  • Use a magic value such as "-1" and have the query define an exception for that situation.
  • Use a magic value such as "-1" for SecurityDrops, and if it is selected have another parameter pop up for SecurityDropValues that is MultiValued and allows the user to input 30, 35, 26, and 40.

If you insist on the direction you suggest in the question, the "solution" would be to make the parameter of type text, and allow the user to input comma-seperated values. You'll have to parse the input for the parameter in the SQL then though, which isn't pretty.

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

Hi Jeroen - just curious, I was a little puzzled at the second tip there - " a magic value such as "-1" and have the query define an exception for that situation."
Create a possible value "-1" with a label "Multiple Security Drops", and if it is selected: show a new multi-valued parameter to allow the user to choose those Drops.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.