Group Footer help 1

[bikerboy718]

I have a group footer that does subtotals. Sometimes the footer extends onto the next page by itself. Is there anyway that i can put the group header information before the group footer information in this case. For example

Page 1

A B C - Group Header
- - -
1 2 3
4 2 1
3 2 5

Page 2
A B C - Group Header
- - -
8 6 9 - Group Footer Total


I have the Group header repeating on every page but it will not display before the group footer if the group footer is the only thing on the page.

 

[lbass]

You could insert another group footer section and place your group header fields in GF_a, with your summaries in GF_b. You would need to format the supracategory Group Footer (above GF_a) in the section expert to "Keep together". Then create two formulas:

//{@reset} to be placed in the page header:
whileprintingrecords;
numbervar cnt := 0;

//{@accum} to be placed in the GH sections, details, and GF_a section:
whileprintingrecords;
numbervar cnt := cnt + 1;

Then in the section expert->GF_a->suppress->x+2 enter:

{@accum} <> 1

-LB

 

[bikerboy718]

LB,

just one question. After i create the formula @accum:

//{@accum} to be placed in the GH sections, details, and GF_a section:


where do i place it in the GH sections, details, and GF_a?
I think i almost understand with the exeption of the placement of accum.

Thanks

Mike

 

[lbass]

Place it in any report section that appears above the group footer (except the page header) and suppress it. The formula counts records/sections and will tell whether the group footer section is the first section on the page.

-LB

 

[bikerboy718]

I got you thanks so much for your help.

Mike