StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POFormatting a Second Page of Details
text
Body
copied!<p>This is a problem I've managed to come up with a semi-solution for in the past, but I thought someone else might know better.</p> <p>I have a report in <strong>Crystal Reports 10</strong> that is used as an order summary form for a production area. We have standard products that only have one item per code, and then we have kits. A kit will have one primary item, and a secondary item, both of which need their own page in this summary as they go to different areas.</p> <p>To accomplish this I've taken the normal details area from the report and made a copy of each section. This second set of details sections only shows when a record contains a kit, and they force a new page before them. To the average observer this makes it appear as though there are two separate items on the order, when in reality there is only one.</p> <p>In my page header there is a flag that needs to show only on these secondary pages. My problem is that there is no special attribute for these second pages that sets them apart from the first page of a record. To make this formatting happen I've created a somewhat effective formula, but it doesn't work in all possible configurations.</p> <p>The formula is:</p> <pre><code>(PageNumber = 2 or ({%kit count} = 1 and (PageNumber - 1) = RecordNumber) or ({%kit count} > 1 and (PageNumber -2) = RecordNumber)) then false </code></pre> <p><code>%kit count</code> is just a formula that gets a total count for kit codes in the report.</p> <p>Currently this works only on a few specific cases. I'm sure there's some kind of pattern in the available values that I could work with, but I'm just not seeing it.</p> <p>I need to be able to trigger this formula on every second page on a kit. How can I accomplish that?</p> <p>EDIT: Screenshots as requested. (Brace yourselves)</p> <p><img src="https://i.stack.imgur.com/vKDjL.png" alt="[Screenshot 1]"></p> <p>(Original at <a href="http://cl.ly/392f033Y131e3r0l100V" rel="nofollow noreferrer">http://cl.ly/392f033Y131e3r0l100V</a>)</p> <p><img src="https://i.stack.imgur.com/N5NfB.png" alt="[Screenshot 2]"></p> <p>(Original at <a href="http://cl.ly/2x1D0t0W0S0j0F0h0S28" rel="nofollow noreferrer">http://cl.ly/2x1D0t0W0S0j0F0h0S28</a>)</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