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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Loss when page changes 1

Status
Not open for further replies.

BFAGG

MIS
Aug 23, 2001
64
GB
I have a report with 2 group levels.
Page headers and footers are displayed.
The data display only shows GH1 and GF2. GF2 contains totals.
All other sections are suppressed.

Headers and footers are set out in columnar format on A4 landscape. Columns are printed down then across.

If group 1 covers > 1 page some of the GF2 entries go missing. eg;

The data should look as below:

GH1 = 'A'
GF2 = 1
GF2 = 2
GF2 = 3
GF2 = 4
GF2 = 5
GH1 = 'B'
etc;

If the data rolls over a page I get
GH1 = 'A'
GF2 = 1
GF2 = 2
---Page Break---
GF2 = 5
GH1 = 'B'
etc;

Any Ideas??:-(
 
Put in a variable to count the number of group 2 footers and use it to put in a page break after every 2 footers. This may leave you with blank areas on some pages, but all the data will show up
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top