Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm trying to figure out, how I can hide those rows in my report where Total Allocation and Total Cost IN BOTH COLUMNS TOGETHER are 0 in SSRS 2008.

For example:

Total Allocation    Total Actual Cost
0                     0                <---- hide
100,00                0                <---- don't hide 
0                     50,0000          <---- don't hide

Here is the screenshot: enter image description here

Thank you

share|improve this question
add comment

2 Answers

Unless I'm missing some nuance, you will simply set the Row Visibility based on the value.

Right click on the detail line and select Row Visiblity...

Row Visibility...

In the window that pops up, select Show or hide based on an expression

Row Visibility display options

Within that expression, you'll use logic like

=Fields!Total_Allocation.Value = 0 And Fields!Total_Actual_Cost.Value = 0
share|improve this answer
add comment

There are two places you can control this visibility. The first is on the row in the tablix; the second is on the row in the Row Groups.

If you change visibility by right-clicking the row in the tablix then on the final report the row will be invisible, but still there.

If you change visibility by right-clicking the Row Groups line then on the final report the row will not be present and the rows beneath will move up fill the gap of the hidden row.

The steps are something like the following.

  • In Row Groups, right-click (Details), click Group Properties.
  • Click the Visibility page.
  • Select (•) Show or hide based on an expression.
  • Click the Expression Builder button.
  • =IIF( Fields!TotalAllocation.Value = 0 and Fields!TotalCost.Value = 0, True, False )
  • Click OK then OK again.
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.