StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Okay this might be tricky to explain but there is a way to do this and I will add steps to follow.</p> <p>Basically what you are doing as adding a flag that is set to true every time the sub report is displayed and set to false at the top of a new page.</p> <p><strong>Step 1.</strong></p> <p>Add a new formula to the main report called <code>SubRepDisplayed</code></p> <p><strong>Step 2.</strong></p> <p>Set the formula to: </p> <pre><code>WhilePrintingRecords; Shared booleanvar subrep; subrep; </code></pre> <p><strong>Step 3.</strong></p> <p>Add another new formula called <code>ResetSubRep</code></p> <p><strong>Step 4.</strong></p> <p>Set this formula to:</p> <pre><code>WhilePrintingRecords; Shared booleanvar subrep; subrep := false; </code></pre> <p><strong>Step 5.</strong></p> <p>Now in the <strong>sub report</strong> add a new formula called <code>SubReportDisplayed</code></p> <p><strong>Step 6.</strong></p> <p>Set this sub report formula to:</p> <pre><code>WhilePrintingRecords; Shared booleanvar subrep; subrep := true; </code></pre> <p><strong>Step 7.</strong></p> <p>Add the formula <code>ResetSubRep</code> to the page header, it can be suppressed.</p> <p><strong>Step 8.</strong></p> <p>In the <strong>sub report</strong> add the formula <code>SubReportDisplayed</code> to any visible section, if possible a report header/footer.</p> <p><strong>Step 9.</strong></p> <p>Finally in the main report again, in the section expert, select the page footer you want to suppress:</p> <p><img src="https://i.stack.imgur.com/rvNSN.png" alt="Section Expert"></p> <p><img src="https://i.stack.imgur.com/WUwqp.png" alt="Suppression screen"></p> <p>and in the suppression formula enter:</p> <pre><code>WhilePrintingRecords; Shared booleanvar subrep; subrep; </code></pre> <p>If you've followed all the steps, the sub report being displayed on a page should suppress the page footer with that formula in.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload