sql-serverreporting-servicesvisual-studio-2019

Is it possible to use a SQL query for setting the AllowBlank property of a parameter?

Is it possible to set the AllowBlank property of a parameter in a SSRS report via SQL query?

I want to do this, because I have in the parameters one which is depending on another parameter.

When the value of the other parameter is "-1" then the value of the dependent parameter shall not be blank.

But just in this case.

Maybe this could be done in the XML with a SQL query like in this example:

<ReportParameter Name="Parameter2">
    <DataType>String</DataType>
    <AllowBlank>SELECT IIF (Parameters!Parameter1.Value = '-1', false, true)</AllowBlank>
</ReportParameter>
Solution

  • You may be able to use two parameters (one mandatory and another one that allows blanks) and change their visibility to make sure only the relevant one is displayed.

    per Razvan Socol in the comments