Answered by:
Checkbox Filter Option in Report Builder

Question
-
Hi,
I wanted to kindly ask if SSRS / Report Builder features a native interactive filter option (e.g. as a radio button, checkbox, etc.)?
For example, a checkbox filter that is a native feature of Power BI:
If not, would anyone know how to build a button that would, upon a click, filter my visualization (I guess by writing an expression that would, on action, pass the filtering parameter(s) to my dataset)?
With thanks and kind regards,
Bogdan
BogdanU
Answers
-
- Proposed as answer by Lukas DreiKleinMicrosoft contingent staff Friday, November 22, 2019 2:29 AM
- Marked as answer by BogdanU Wednesday, December 4, 2019 9:16 AM
-
Hi Bogdan,
As far as I tried, we could not realize what you want with Boolean type parameter in SSRS.
Unfortunately, neither of the two is supported for now. reference : Changing the default values of the boolean data type in SSRS report parameter
Regards,
Lukas
MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
- Marked as answer by BogdanU Wednesday, December 4, 2019 9:18 AM
All replies
-
- Proposed as answer by Lukas DreiKleinMicrosoft contingent staff Friday, November 22, 2019 2:29 AM
- Marked as answer by BogdanU Wednesday, December 4, 2019 9:16 AM
-
Hi, Olaf.
Thank you for the fast and helpful reply.
Although this qualifies to be the answer I was looking for, I just wanted to kindly ask a bit more, please:
The filtering that I've got is limited to True/False options:
- Is there a way to disable one of the two buttons, so that the end User only sees one (i.e. True)
- Is there a way to change the prompt names "True" and "False" to something else?
With thanks and kind regards,
Bogdan
BogdanU
-
Hi Bogdan,
As far as I tried, we could not realize what you want with Boolean type parameter in SSRS.
Unfortunately, neither of the two is supported for now. reference : Changing the default values of the boolean data type in SSRS report parameter
Regards,
Lukas
MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
- Marked as answer by BogdanU Wednesday, December 4, 2019 9:18 AM
-