Scroll

Conditional Row Suppression

Conditional row suppression allows the user to hide rows of data that meet a predefined condition.

 

Example

The below example displays contact information for company employees residing in the UK and USA. The Employees.Region field stores State values for USA residents and null value for UK residents.

 

 

Here's how this data is returned without the use of row suppression. Note that Employees.Region doesn't return any information for the first employee but is necessary to show the State for the bottom two. 

 

In order to hide these null value cases, we'll use Conditional Row Suppression. 

 

Applying Conditional Suppression

Select the cell formatting tool, or right-click first cell containing the data you want to conditionally affect and select the same tool. ()

  • As the action, select "Suppress Row."
  • Select the function icon, shown below.

conditional_row_suppression.png

 

In the Formula Editor, we'll set a simple formula for the row of data we want to represent the respective employees for that row.

Let's devote Row 4 to USA residents by suppressing records where Employees.Country = "UK." 

conditional_row_suppression4.png

 

Let's, accordingly, devote Row 5 to UK residents by suppressing records where Employees.Country = "USA." 

 conditional_row_suppression3.png

 

Now when we execute the report, our data will return without null values:

 

Conditional Row suppression is extremely useful for delineating similar but distinct results from the same data fields. 


Hidden Article Information

Article Author
Nick
created 2016-03-07 23:05:42 UTC
updated 2017-07-11 20:04:15 UTC

Labels
columns And Rows, suppression, conditional,
Have more questions? Submit a request