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.

All responses (6)

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 9,914 Super User 2024 Season 2 on at

Like (1)

Report

Management report: How to hide value whether it is zero or not

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
Suggested answer

Ammad Jawed 24 on at

Like (0)

Report

Management report: How to hide value whether it is zero or not

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
Waed Ayyad 6,502 Super User 2024 Season 2 on at

Like (0)

Report

Management report: How to hide value whether it is zero or not

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

salman ahmad 97 on at

Like (0)

Report

Management report: How to hide value whether it is zero or not

Hi you can put this formula IF@row<0 use the no printing option in the control column
Layan Jwei 7,379 Super User 2024 Season 2 on at

Like (0)

Report

Management report: How to hide value whether it is zero or not

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

Ramit Paul 22,307 Most Valuable Professional on at

Like (0)

Report

Management report: How to hide value whether it is zero or not

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