CODEWITHSUNDEEP
visual-studio-2010reporting-services
Wessel
Wessel

Reputation: 290

SSRS Parameter Issue

I am trying to filter data using a text field, However when I specify the available Values to the dataset and field that I am using I recieve this error.

enter image description here

If I remove the Available values, The report runs fine.

I am using Visual Studio Ultimate 2012, with SSRS addon.

Upvotes: 0

Views: 67

Answers (2)

Daniel Hanczyc
Daniel Hanczyc

Reputation: 182

Get the distinct colors list on additional data-set and set it up as default value for your color parameter. Remember that order of parameters is also important.

Upvotes: 0

Ethan Pelton
Ethan Pelton

Reputation: 1796

The available values can't be populated from the same data source that they are being applied to.

Create a separate data source for your available values and make sure they can populate without user interaction - without their own parameters in other words.

Upvotes: 1

Related Questions