Question
I have a report with sections in it. I have inserted a cell, which is repeated in each section. I only want the cell to appear for one of these sections, not all of them.
Answer
It is possible to hide cells occurring within sections.
Solution
Click on the text cell, then go to Format > Cell. Select the Appearance tab. Check the Hide Cell box, then click on Edit Formula to create a formula to hide the cells you do not need. Click on OK.
Example
A report has a section on campus. A text cell is entered next to the “St Lucia” section with the text “* Includes Herston”. This is not required for the Gatton or Ipswich sections.
Click on the text cell, then go to Format > Cell. Select the Appearance tab. Check the Hide Cell box, then click on Edit Formula to create a formula to hide the cells you do not need.
The formula to use is: <Student Campus Description> InList (“Gatton”, “Ipswich”) – this will HIDE the cells in the Gatton and Ipswich sections.
Click on OK.