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

Section Expert (Reset Page After) not working like I want 1

Status
Not open for further replies.

shricky

Programmer
Mar 6, 2007
17
US
If Group 2 has multiple pages of data in it then Group 1 will not reset properly. I have a large gap (white space) in the report output if there are multiple pages to that section. If there is only 1 page in that section then it resets fine. any thoughts on how to fix this?
 
If this is a formula, you most likely have the reset formula in the group header, which is also repeated on every page. If so this is expected bahavior. You need to preface your reset formula with the following:

Not InRepeatedGroupHeader

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"What version of URGENT!!! are you using?
 
Your post is very unclear. There is no feature in the section expert called "reset page after". It is unclear whether by reset you mean you have a variable that isn't resetting or whether you mean the group #1 header isn't in the position you would like to see (immediately following the last Group Footer #1 of the previous group instance). Please clarify.

-LB
 
sorry, it is called "new page before". It does create a new page but there is a lot of "white space" in the output (which makes the report not look right). It only does this if the detail is more than one page for that group. if the detail for that group is <= 1 page then it formats it perfectly.
 
You can use a formula in the "new page before" formula section (x+2):

not onfirstrecord

...to eliminate the initial white space, but if you ask for a new page before the beginning of each group, you will get extra white space whenever the details end before the end of a page. There is nothing else that COULD happen in that situation.

-LB
 
It didn't work when i put it in.

Group 1 H Status
xx
xx
xx

Group R Status

all white space until the next page then detail starts

xx
xx
xx
 
In the section expert, you must have the group header selected when you add the new page before formula.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top