Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group Footer appearing above Group Header 2

Status
Not open for further replies.

samson123

Programmer
Jun 17, 2005
79
US
I am using CR XI, Access 2000

The Report has following layout

GH1
D
GF1

I have formula to stop the column headers from printing after change of every group.

In the PF, I have a @reset formula
@reset
-------
whileprintingrecords;
numbervar linecnt := 0;

In the GH1 I have a @incrementcount formula
@incrementcount
---------
whileprintingrecords;
numbervar linecnt:= linecnt + 1;

In the GH1 section --suppression (x+ 2)
I have

whileprintingrecords;
numbervar linecnt;

linecnt <> 1

I have "Repeat Group Header on each page" in GH1

My problem..

In page 2 I get the GF1 above the GH1(labels)..I am confused ?? ?

What is wrong here
 
Go to the section expert and make sure you don't have "new page before" checked on the group footer section. It should be "new page after".

-LB
 
LB,

Thanks as always for quick response..

I do not have "new page before" checked.. Again I do not need a new page after change in group. I need to display different groups on the same page...

 
You haven't explained why you're not using the page header, since you want just one header per page. I'd assume it was part of the design of a complex report, but page headers can be made conditional, like other sections.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
This sounds quirky. Try removing the formulas and the conditional suppression, i.e., let the report revert to its original layout, and then try adding them again.

-LB
 
Madawc,

I call myself a "Moron".. Why did I not have a page Header ?

Thanks for pointing this simple thing to me..

LB,

I cleaned up everything and reports looks as expected..
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top