snippetsqlModerate
How to hide rows in SSRS report?
Viewed 0 times
ssrsrowsreporthowhide
Problem
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
Here is the screenshot:
Thank you
For example:
Total Allocation Total Actual Cost
0 0
Here is the screenshot:
Thank you
Solution
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
In the window that pops up, select
Within that expression, you'll use logic like
Right click on the detail line and select
Row Visiblity...In the window that pops up, select
Show or hide based on an expressionWithin that expression, you'll use logic like
=Fields!Total_Allocation.Value = 0 And Fields!Total_Actual_Cost.Value = 0Code Snippets
=Fields!Total_Allocation.Value = 0 And Fields!Total_Actual_Cost.Value = 0Context
StackExchange Database Administrators Q#53727, answer score: 17
Revisions (0)
No revisions yet.