CODEWITHSUNDEEP
sql-serverreporting-services
riaz.usmani
riaz.usmani

Reputation: 271

I want to display field on Parameter Value

I have a Parameter @Language in SSRS Report which have two value English=2 and French=1 I want to display different fields on parameter value like

=IIF(Parameters!Language.Value=1,Fields!new_french.Value,Fields!new_english.Value)

but it shows error.

Upvotes: 0

Views: 192

Answers (1)

gannaway
gannaway

Reputation: 1882

Try using the First aggregate and scoping the field names to their dataset name. For example, if the dataset name that contains the new_french and new_english columns is named Languages then the expression would be:

=IIF(Parameters!Language.Value=1, First(Fields!new_french.Value, "Languages"), First(Fields!new_english.Value, "Languages"))

Upvotes: 0

Related Questions