Announcements
No record found.
Hi all ,
I have a parameter show zero balance ( yes , no )
if the user turns on the show zero balance He get the data with zero else they are turned off
How can I do it as show or hide expression in SSRS report
Thanks
Hi lala,
When you say, data with zero, are you referring to hiding a row in the report, or only hiding a text box?
To look at examples for visibility expressions, you can check SalesInvoice report., right click a few the rows and check the row visibility condition.
You can write a similar condition based on the parameter value.
Hello
If I want to hide a row in the report , what the condition to hide the zero values
I believe you will have parameter on your report dialog. I would recommend to handle the logic in your code itself. Are you using DP class or query for your SSRS report?
Yes I have a parameter : Show zero balance
Im using DP Class
i need the condition to hide or show the zero balance
Good. Populate your temp table based on your parameter. If it says show zero 'yes' then only insert zero value data in your temp table.
I need the code for this condition
You can use something like this in the visibility expression -
=iif(Parameters!ShowZero.Value = "Yes", false, true)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 689
André Arnaud de Cal... 478 Super User 2026 Season 1
Syed Haris Shah 258 Super User 2026 Season 1
