Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by Community member

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.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

I dont think you will be able to do that, total can not be hidden.

Was this reply helpful? Yes No
Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

salman ahmad 176 on at

Like (0)

Report

Hi you can put this formula IF@row<0 use the no printing option in the control column

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Suggested answer

Ammad Jawed 17 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No