Re: Page/report totals in REPORTS 2.5

From: Caryl Lee Fisher <cfisher.dulcian_at_worldnet.att.net>
Date: 1997/12/06
Message-ID: <66bp1o$bgp_at_mtinsc03.worldnet.att.net>#1/1


Cool question! I liked this one.

You can't detect you are on the last page. So you need a trick.

Add a dummy row to your report query, i.e. a union that won't show up as real data. In your repeating group, use a format trigger that will set a flag in a package variable that the last record has been encountered
and not print the dummy record.

Use the value of the package variable to tell which summary to print.

Be sure to adjust any summary cols that
use count of the detail rows.

Paul Dorsey
Dulcian, Inc.

Michael Anderson <manders_at_mbnet.mb.ca> wrote in article <34880af4.1274916_at_news.mbnet.mb.ca>...
> 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
>
  Received on Sat Dec 06 1997 - 00:00:00 CET

Original text of this message