Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

CraigBest (Programmer) (OP)
19 Mar 02 11:56
How can I tell a report to print the page footer ONLY on the first page of a report?

Also, is there a way of determining at the bottom of the page if the details section is still being written of if you are in the group footer section?  How can I use this to show or not show a text field that says "Additional details on following page"?
Ngolem (Programmer)
19 Mar 02 12:23
In the conditional suppress of the PageFooter

Pagenumber <> 1 should do it

As far as being at the bottom of a page that is not easy. Crystal itself doesn't indicate position on a page.

In desperation (because of awkard pagesplitting) I created a line counting formula(s) which had each line type with the amount of inches that that line would approximately use

Eg. A detail line might use .75" whereas a header line would use 1.5"

I then sprinkled these different formulas suppressed on their appropriate section...summing the values...being reset when on a new page.

then in the "new Page Before" at critical points...eg. the start of a major header...I would split to the new page if a sum was >= a certain amount. What would this value be? Well I would display the valeus first and veiw the reults to obtain an optimum for the report then suppress the displays.

It is tedious and reserved for the "Absolutly-must-be-perfect-as-possible" reports

But it worked

Jim
CraigBest (Programmer) (OP)
19 Mar 02 12:29
Jim, thanks, your formula did the trick.

I was afraid of the second part.  I may be able to get around it by including a line that says, "Additional details may be listed on subsequent pages".  If I can do that I will be OK.  I wanted to show a message on the first page if the details section spilled over onto one or more additional pages.
CraigBest (Programmer) (OP)
19 Mar 02 15:02
Okay, I got the page footer to print only on the first page.  But I have three more pages of legalese text that need to print after the first page, and now the page footer takes up the same space on every subsequent page, even though it doesn't print.  I get 3-4 inches of blank page at the bottom of every subsequent page.

Any way I can fix this?

Craig in NJ
Ngolem (Programmer)
19 Mar 02 15:36
did you place the formula : Pagenumber <> 1

In the conditional suppress of the Page Footer section expert or in the suppress of the fields within the page footer.

I think you put the conditional suppress in the fields

As far as the Additional Details warning.

do you split to a new page often to start the terms part on a fresh page?

perhaps we can set a flag and place this in the footer suppressed

@DetailAlert1
WhilePrintingRecords;
Numbervar Alert := 2;

place this next flag in the details section

@DetailAlert2
WhilePrintingRecords;
Numbervar Alert := pagenumber;

now create a subsection of the page footer and then place the normal page footer in PageFooter(b) and the following text field in the right cornor of PageFooter(a)

"Additional Details on subsequent pages"

in the conditional suppress of the PageFooter (a) put the formula

WhilePrintingRecords;
Numbervar Alert ;

Alert > 1;

this will suppress this subsection once you are over 1 page or you are on page 1 but finished all details

Hope this helps

Jim
JimBroadbent@hotmail.com

CraigBest (Programmer) (OP)
19 Mar 02 15:45
Hi Jim

Nope, set it up just as you suggested, in the Section options.  Checked the Supress checkbox, inserted the formula into the formula editor.  Works great on the first page, but each subsequent page has a blank sections near the bottom same size as the page footer.

I will look at your suggestions regarding additional details and get back to you.  Thanks again.

Craig in NJ
Ngolem (Programmer)
19 Mar 02 18:17
take the check off the suppress but leave the formula in the conditional suppress...that may be the prob...
CraigBest (Programmer) (OP)
20 Mar 02 9:27
Hi Jim

Tried your suggestion, did not help, still have large white space at end of subsequent pages.
Ngolem (Programmer)
20 Mar 02 10:22
Is it because of the other fields having "Keep together" checked in the format editor...or perhaps "Keep together" checked in other sections in the Section Expert....this isn't a page footer problem, I don't believe

Jim
CraigBest (Programmer) (OP)
20 Mar 02 11:29
Nope, I wish it were 'cause I'd be done.

All sections and fields have had any "keep together" settings turned off and it makes no difference.  The Page Footer sections have "keep together" automatically turned on and I can't turn that off (system-disabled).  

Any more ideas?  I'm so close...
Ngolem (Programmer)
20 Mar 02 12:04
I think I know the cause...we have 2 sections to the page footer...don't we?

Now we have 2 situations

1. where the details are all on page 1 and the terms follow on subsequent pages

2. where details split across 2 pages and then the terms follow on subsequent pages

let me ask you this....If the details split across 2 pages, do you want the footer on the first and second page??

See...in the Section expert for a given section there are conditions that can apply to the complete section (in this case our Page footer) no matter what (ie. they over ride the subsection conditions sometimes) and then we have conditions that apply to individual subsections themselves

We may have a conflict...or not set them up properly...

Please answer the senarios I mentioned above

Jim
CraigBest (Programmer) (OP)
20 Mar 02 12:42
Jim, thanks for keeping up with this.

<< I think I know the cause...we have 2 sections to the page footer...don't we? >>

Yes.  One that has a few text items (signature lines) and a paragraph of legalese that must appear on the first page, and a second that shows the recipient name (Vendor copy, File Copy, etc.) and the page number.

<< Now we have 2 situations

1. where the details are all on page 1 and the terms follow on subsequent pages

2. where details split across 2 pages and then the terms follow on subsequent pages

let me ask you this....If the details split across 2 pages, do you want the footer on the first and second page?? >>

No.  What I want to have is the first page footer (PF1) print on the first page only, and have the Second (PF2) print on all pages.  If the details spill over from the first to the second page, the page 1 footer should still print on page 1 but not subsequent pages.  After the details print, there are about 3 pages of group footer, all one text item (many paragraphs of legalese), that print following the details. It's this group footer that's not reaching the bottom of the page on pages 2+.  

<< See...in the Section expert for a given section there are conditions that can apply to the complete section (in this case our Page footer) no matter what (ie. they over ride the subsection conditions sometimes) and then we have conditions that apply to individual subsections themselves

We may have a conflict...or not set them up properly...

Please answer the senarios I mentioned above >>

There you go.  Hope what I've written makes sense.

Craig in NJ
Ngolem (Programmer)
20 Mar 02 13:22
What about the "Additional Details on subsequent pages" comment...where would that come in??
*********************************************************
You want PF1 on just the first page so in the conditional suppress for JUST this section put the formula (I think this replaces the Conditional suppress we had before)...if it doesn't then this below in PF1 should be the ONLY conditional suppress on ANY section of the Page Footer...including the overall PF settings

WhilePrintingRecords;
Pagenumber > 1;

*********************************************************

Now you could put a text field in the PF1 saying

"Additional Details on subsequent pages"  and in the conditional suppress of just that field you could put

WhilePrintingRecords;
Numbervar Alert ;
Numbervar Alert <> 2;

This would not show this field if the details didn't split over 2 pages...on subsequent pages it won't matter because the entire section PF1 will be suppressed.

*********************************************************

As far as PF2 goes...you don't touch any suppress since you want this on every page.

Hope this works now
Jim

CraigBest (Programmer) (OP)
20 Mar 02 15:48
Jim,

Main Page Footer section = no restrictions (Except system-controlled New Page After setting).

Page Footer 1 (PF1) = no restrictions except The conditional formula placed in the Suppress option, as you wrote it:

   WhilePrintingRecords;
   Pagenumber > 1;

No restrictions in PF2.

Still can't get Group Footer to print below reserved area for PF2 on subsequent pages (>1), even though suppressed section doesn't show.

Feeling very frustrated...  Not your fault, of course, I wish they didn't want to do it this way, it would make my life so much easier.
Ngolem (Programmer)
20 Mar 02 21:19
I think I know what the problem is...it happens every now and then when Crystal changes pages in a footer. It seem to forget which page it is on.

Are you generating more than one contract at a time?

"After the details print, there are about 3 pages of group footer"

WHich group is this in??  I am having trouble imagining your report structure...is this in the group that splits to a new page if it starts on page1??

Layout the structure in detail for me .... ie:

Group1H - (based on what?...suppressed or not...)
Group2H -     "               "
...
Details
...
Group2F - (what is printed suppressed or not, on page 1?)
Group1F - (what is printed suppressed or not, on page 1?)
Page F1 - (what is printed suppressed or not, on page 1?)
Page F2 - (what is printed suppressed or not, on page 1?)

I don't seem to have the complete picture. lay it out in detail.

Can this automatic legalese not go into a report footer that can be several pages long?

or perhaps we can create a dummy group...is there anything else in this Group footer?

If not then surround this group with another "dummy group"

create a formula

@dummy_Group

If 1 = 1 then  "Legalese";

Crystal will accept this since it doesn't know what the value is until it is run...then it sets the group to a constant.

Place your legalese in the footer of this group and suppress the header. In the section expert for this footer do a conditional "New Page before"

WhilePrintingRecords;
Pagenumber = 1;

Give me a complete detail of the layout...ok

Jim


digitalquatro (Programmer)
14 Nov 02 20:50
Hi Jim, I'm Efrain i wanna thank you too, your formula did the trick. It works on a Page header suppress.
Appreciate.
CraigBest (Programmer) (OP)
18 Nov 02 12:17
Hi Jim

It's been a while, and since the thread came up again (thanks to DigitalQuatro) I thought I'd get back to you on it.

For the most part your suggestions worked out well.  eventually took out the two Page Footer sections and made it one PF section with the Signature block, and moved the 20" text box of legalese to the Report Footer section.  This was done after the first time I tried to print a report that had more than one page of details, and the report had a complete cow.

Moving the large block of text to the report footer section sems to have had exactly the results I wanted.  All of the other difficulties went away, pretty much.

Just wanted to thank you again for your help, it was really important to me and got me through a rough spot, to where I could figure the rest out for myself.

Craig in NJ

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close