calc for an optional last page

[rivet]

I am developing a quote DB that needs an optional last page that will list terms.

The trick is the solution must have the terms on the same layout as the rest of the quote, that way the user can output a pdf to one file.

[BruceJ]

I'm having a hard time determining what your question is.

So I'm going to take a stab in the dark...

One way to do this is have a layout for printing/PDF that contains a calc field. The Calc field could be:

If( termsField = "Y", termsTextField , "")

On the layout set Sliding/Printing of the Calc field to slide up.

If the user checked "Y" to include the Terms, then they will show up, if they click "N" or leave it blank, then the Terms will not show up.

--If your terms are always the same, make it termsTextField a global field. If the Terms are compiled of many fields and selections, then make the termsTextField a calc that combines all the contents, inserting the proper spaces and paragraph returns, etc. as appropriate.

[The Bridge]

You should be able to accomplish this by placing a global Terms field on a Trailing Grand Summary part. Set the Terms field to slide and to reduce size of enclosing part. Just make sure that the field fits snugly within the part (no blank space above or below).

[rivet]

sorry what I need is a dedicated last page for the terms only.

so if a two page quote is to be send with term there would be thee pages in total.

[The Bridge]

You can specify in the Trailing Grand Summary part's options to Page Break before each occurrence. This should do the trick.

[LiveOak]

I'd put the last page in a Subsummary part. If the sort order is correct, the subsummary will display, if not, it won't. You control this by sorting or not sorting.Set the subsummary to start on a new page.

-bd