SYMPTOM:
When a document has a blank tag (page), the export files in PDF format and in Excel format are not the same. The PDF file will omit the blank page, but the Excel file will retain it.
STEPS TO REPRODUCE:
In Strategy Tutorial, do the following:
- Create a report called with the following structure.
Attributes: ,
Metrics: ,
Filter: Add two prompts to the filter: and . - Create a second report called with the following structure:
Attributes: , - Create a document and add and as datasets to this new document.
- In this document, create three layouts called , , and
- In each layout, go to Format > Document Properties > Layout Properties and ensure that "Use shared page header/footer" is unchecked.
- In each layout, go to View > Sections, and select only the "Detail Header" section. Uncheck all the other options.
- Set the as the grouping and sorting dataset for all the layouts.
- In the first layout ("Static Data"), add the grid to the "Body" section.
- In the second layout ("Revenue Summary"), add the grid to the "Body" section.
- In the third layout ("Disclaimer"), add just a text box with some static text to the "Body" section.
- Go to the "Body" section of the second layout ("Revenue Summary") add the following conditional formatting rule:
IS NULL OR Equals 0 ---> Action = Hide Object - Save and close the document
- Run the document and select a set of prompt answers which will return no results in the report - e.g. select Dec 2011 as the month.
- When the document is run in Desktop, it is observed that the second layout tab ("Revenue Summary") is visible, but the entire layout is empty due to the absence of data and the conditional formatting rule as shown below.
