Show or Not to show zero balance in SSRS Report

(0) Share

Report

Posted on by GAE

130

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

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

RE: Show or Not to show zero balance in SSRS Report

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.

Was this reply helpful? Yes No
GAE 130 on at

Like (0)

Report

RE: Show or Not to show zero balance in SSRS Report

Hello

If I want to hide a row in the report , what the condition to hide the zero values

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (0)

Report

RE: Show or Not to show zero balance in SSRS Report

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?

Was this reply helpful? Yes No
GAE 130 on at

Like (0)

Report

RE: Show or Not to show zero balance in 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

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (0)

Report

RE: Show or Not to show zero balance in SSRS Report

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.

Was this reply helpful? Yes No
GAE 130 on at

Like (0)

Report

RE: Show or Not to show zero balance in SSRS Report

I need the code for this condition

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
RE: Show or Not to show zero balance in SSRS Report

You can use something like this in the visibility expression -

=iif(Parameters!ShowZero.Value = "Yes", false, true)

Was this reply helpful? Yes No