Re: Page/report totals in REPORTS 2.5

Michael Anderson wrote:
>
> I have a report where I print a page total on all pages. But I don't
> want to print a page total on the last page, I want to print a report
> total in the same place.
>
> Can I do it as two different display items, displaying one and hiding
> the other at the approriate time? If so, how do I know if I'm on the
> last page or not?
>
> Thanks for you help,
>
> Michael Anderson
> Mb. Education & Training
> 307 - 1181 Portage Ave.
> Winnipeg, Manitoba R3G 0T3
> Voice: (204) 945-1848
> Fax: (204) 948-2542
> manderson_at_edu.gov.mb.ca
> manders_at_mbnet.mb.ca

The answer to this is to correctly set the print conditions for the 2 totals. Set up two Summary columns, one which resets at the page level (e.g. PAGE_TOTAL) and one which resets at the report level (e.g. REPORT_TOTAL). Then when you create your report add two fields referencing each of the TOTAL columns created to the report somewhere outside your repeating group. You will have to do this manually because the default layout utility will not (or cannot) set up page level summaries for you.

Then change the Print Condition properties of each field (under the General Layout tab) - the field for PAGE_TOTAL Type be for "All But Last" and the Object should be "Anchoring Object", and the field for REPORT_TOTAL Type should be "Last" and the Object should also be "Anchoring Object".

You may get the error "[FIELD] Has An Invalid Print Condition" when trying to run the report. This would have to do with the setup of your layout, and you may need to put explicit anchors on your TOTAL fields. The online help goes into more detail on the "rules" for print conditions. Check these if all else fails, but generally speaking its relatively easy to accomplish the task you need.

Hope this helps.

-- 
 ___ ___ ___ ___ ___ ____   ___ ___ ___ _  _  _   _  _ ___ ___  ___
| _ \   | _ \ __| _ \   _| | __| __| _ \ \| |/ \ | \| |   \ __|/ __/
|  _/ | | _ < _||  _/| |   | _|| _||  _/    | _ \|    | | | _| \__ \
|_|_\___|___/___|_|_\|_|   |_| |___|_|_\_|\_|/ \_\_|\_|___/___|/___/

********************************************************************
        Robert Fernandes - LLNL AIS Dept

        Phone:  (510) 423-1397     Fax:  (510) 423-5882
        Email:  rfernand_at_llnl.gov - or - fernandes6_at_llnl.gov
********************************************************************