Forum Discussion

Helper I

6 years ago

Solved

Use if parameters in query

Is it possible, and how, write in query sql SELECT .... CASE WHEN @Visualizzazione ='D' THEN Sa ELSE '' END Sala FROM ... Thanks

v-lionel-msft
6 years ago
Hi RiccardoBefore ,

Do you want to use the 'what if' parameter in the sql query?

It's impossible to achieve the idea in current version(2.83.5894.281 64-bit (July 2020)).

But you can use 'query' parameter to create dynamic data sources.

Dynamic Data Masking and Query Parameters

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helper I

6 years ago

Thank you, amitchandak .

I would have preferred a solution similar to that of Reporting Services.

This use of parameters is not usable by customers.

Thanks.

Riccardo

Community Support

6 years ago

Hi RiccardoBefore ,

Do you want to use the 'what if' parameter in the sql query?

It's impossible to achieve the idea in current version(2.83.5894.281 64-bit (July 2020)).

But you can use 'query' parameter to create dynamic data sources.

Dynamic Data Masking and Query Parameters

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.