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

Suppress header 1

Status
Not open for further replies.

slim2

Programmer
Oct 18, 2001
94
Jim if you see this post.. I applied your solution to supressing the header in the group break, and it worked perfectly. I added another line or two to the footer and all of a sudden I am getting a header only page before each printed page. A 2 page footer print at the group break prints 4 pages with one blank "header only" page before each one.

Any ideas as to what i can look at.
 
Show me the modifications that you made...

"I added another line or two to the footer"

What do you mean here?? Added more subsections?
What was the effect of the footer additions...ie did it increase the footer size dramatically?

What about the "Keep Together's" in the section expert...are they on?? If they are then you may be dragging a footer across to Page 2 because now it is too large to print entirely on Page 1.


How did this get to be 2 pages??? Sounds like more than a line added :)

Try to sketch out how this report is set up now so I get a picture of what is happening...sort of blind here :)

Jim
 
Say that the report is grouped by salesmen and at the group break the totals are calculated. I hope I have described it as you asked.

Thanks again

RP
PH

D (suppressed) used to accumulater totals
GFa (suppressed) used to calculate totals for footer categories
GFb (totals for categories by month) (keep together)
Categ .......
Categ .......
etc
@FlagPageHeaderSuppress (suppress formula)
whileprintingrecords;
numberVar Flag := 1;

----------------------------------------------------------------------
GFc (additional catergories, page break here because GFb and GFc will not fit
on one page and this section is a logical break) (newpage after, keep together)
Categ ..........
Categ ..........

@FlagPageHeaderSuppressReset (rest suppress)
whileprintingrecords;
numberVar Flag;
Flag := 0;


RF
 
I think you are packing too much into GFb...with a "Keep Together" on it the entire section must fit on Page one or it will be dragged over to page 2

"
Categ ....... (How Big is this little bit??)
Categ ....... (How Big is this little bit??)
etc <...... (this scares me :), is this large??)
&quot;

When you add these to the footer, do you block out the complete space that is required or is there &quot;can grows&quot; on the fields.

Now tell me...if this splits to a new page due to the above...do you want the Page header to show??...

See I am not sure when the flag is evaluated...since it is in the same section as the rest it might be done first so when you get dragged over the flag is now set already.

My suggestion is to break up GFb into 3 subsections with the Flag formula in the last of the 3.

Is it necessary for the &quot;Keep Togethers&quot; on the sections? I think they are made that way by default. If it looks ok with half a footer on one page and rest on another...I'd take the &quot;Keep Togethers&quot; off..try it and see what it looks like.

I would similarly break up GFc as well and put the reset formula in the first one.

Hope this helps
Jim
 
YES that helped! removing the keep together worked. almost

GFb fits on one page. GFC also fits if there is no header.

The blank headers are gone but the first page break prints the header which causes the next section to go to 2 pages but the 3 rd page is ok without a header. So i guess the evaluations of the suppress is as you thought. i will try to fix that. Thanks for the keep together tip, I could not find any info on it in Crystal help.
 
I cannot get the header to suppress after GFb the supress flag is set there and the reset is in the page footer.
 
don't put the reset in the pagefooter...place it in GFc

Also...do you never want the header to repeat? If so there is a checkbox &quot;repeat header on new page&quot; or something like that....right-click on the group header in th egrey LHS margin...choose &quot;change Group&quot; and remove the check for that option

Jim
 
Jim,
I have gotten it to work with your second choice, PageNumber > 1.

I printed the value of flag on the page header and in each group section. While it was 1 in the group sections, it was always 0, as I would exepect since the header always printed, on the page header. I will pursue working on option 1 since I think it is more flexible for certain conditions.

Thanks for all your help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top