Editor's Note: The first edition of this article was written by Ajay Varghese.
In this last part of the series, we will take a look at how conditional formatting can help us hide/display a section of the report. Conditional formatting refers to those formatting that are triggered only when certain condition is satisfied. Note that these formatting will override any fixed formatting done earlier using the Format Editor.
For our current requirement, the Group 1 Footer (Store Details) should be visible only when the Store details are being displayed, and should be hidden while displaying the Book Details. In other words, we need to get rid of the dangling parent row. To achieve this, we will take an approach of assigning a value to a variable in the higher level section (Report Header) and displaying the details depending on the value of the variable in the lower level sections. The following steps can be used to implement this :