Search code examples
sqlreporting-servicesssrs-2012

REPLACE TEXT in SSRS (based on Parameter)

just a quick question, i have an issue with SSRS, i have 2 parameters, lets say 'parameter_1' and 'parameter_2' i need to change a text in text box (company name 1 and 2) if one of them (parameter) is on,

=IIf(Parameters!FilterParameter.Value="parameter_1" then "company_name1")

=IIf(Parameters!FilterParameter.Value="parameter_2" then "company_name2")

cant figure out with syntax, please assist

Solution

  • You question is not very clear. You say you have 2 parameters, but it sounds like you have 1 parameter with 2 available values.

    If that is correct and you simply want to return a different value depending on which is selected then you could do something simple like

    =SWITCH(
        Parameters!FilterParameter.Value="parameter_1", "Company_Name_1",
        Parameters!FilterParameter.Value="parameter_2", "Company_Name_2",
        True, "Unknown company"
        )

    alternatively, why not just set the parameter label to the company name you want, then you can just use

    =Parameters!FilterParameter.Label

    If I have misunderstood then please clarify your question.