Finance | Project Operations, Human Resources, ...

Report Designer: How to hide value whether it is zero or not

(0) Share

Report

Posted on by CU27040900-7

Hi guys. I am trying to hide value whether it is zero or not. (I know the way to hide value when it is zero.)

What I am trying to do is :

1. Calculate total value.

2. If total is zero, hide the row.

3. If total is not zero, keep showing the row but hide total value.

Description should be still shown on the report, I want to hide only value.

If anyone have an idea, please help me.

All responses (6)

Answers (0)

Sort by

Suggested answer

Ramit Paul 22,809 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I dont think you will be able to do that, total can not be hidden.
Layan Jwei 8,284 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi community member,

Is this SSRS report? If yes,

You could put this on row visibility as an expression:

=IIF(SUM(Fields!YourField.Value) = 0, True, False)

Or if you already have a total field:

=IIF(Fields!TotalField.Value = 0, True, False)

And on the total textbox for the total, you can put the same expression for visibility

I didn't try it before but that would be me my guess.

Thanks,

Layan Jweihan
Suggested answer

salman ahmad 272 on at

Like (0)

Report
Copy link

Link copied!

Hi you can put this formula IF@row<0 use the no printing option in the control column
Waed Ayyad 9,218 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi community member,

You can add expression for hidden in the SSRS report as the following:

But are you sure from the re

2. If total is zero, hide the row.----
3. If total is not zero, keep showing the row but hide total value.

=IIF(SUM(Fields!YourField.Value) = 0, True, False)

Or if you already have a total field:

=IIF(Fields!TotalField.Value = 0, True, False)
Suggested answer

Ammad Jawed 17 on at

Like (0)

Report
Copy link

Link copied!

HI,

In management reporter, you can either hide the row completely or make it visible. It can not be hidden based on the condition that has been shared in the query.

This condiition can only be achieve through SSRS report.

Regards

Ammad Jawed
Suggested answer

Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

i think in your report design you must :

1. select your field

2. right-click button and click on proprties

3. click on visibility

4. select "Show or hide based on an expression"

5. click on function icon

6. set expression for hidden

7. click OK and save