terms and conditions

[LucasH]

Hi guys,

Question for you. using CR10 against my accounting system and we have a crystal report that generates a purchse order. I want to append a 3 page terms and conditions document (either word or PDF) that prints out for every po printed, could be multiple.

I am wondering what section to put it in to print correctly. I already have data in the page footers that I don't want to move. If I put the terms in the last Group Footer, it prints, but it also prints the page footer info that I don't want to print when the terms prints (like totals, etc). Make sense? Basically I just want to append this document after each po prints.

Any ideas? I am pretty good with Crystal just a little out of practice.

Thanks!

 

[rjoubert]

Report Footer

 

[LucasH]

I need it to print for each po selected (usually multiple). If I put it in the Report Footer it will only print once, correct? That won't work for me.

 

[rjoubert]

I guess I missed that "could be multiple" part in your OP. Sorry...

My only thought would be to put the terms in that last Group footer, like you said you did, then conditionally suppress the page footer so it doesn't print with the terms and conditions.

 

[LucasH]

No problem.

how do I suppress the page footers? I am looking at other posts and it mentions creating a formula with whileprintingrecords but I am confused how that works. What do you suggest?

Thanks for the help

 

[rjoubert]

I was thinking that if your POs are always one page long, you could suppress the page footer where PageNumber > 1.

 

[lbass]

Create two formulas:

//{@false} to be placed in the PO Group header:
whileprintingrecords;
booleanvar flag := false;

//{@true} to be placed in PO GH_b where the T&C are:
whileprintingrecords;
booleanvar flag := true;

GH_b should be formatted with new page before and new page after. The format the page footer with this formula:

whileprintingrecords;
booleanvar flag;
flag = true //note no colon

-LB

 

[LucasH]

So the actual formula goes in the section (and is suppressed)? thats what I was confused about.

What about suppressing lines in the GH_b that extend from the Details through the footer and into the page footer? Possible to suppress those when printing the T&C?

 

[lbass]

Who are you talking to?

You can't conditionally suppress inserted lines, so you would have to use lines from a text box, an dplace them separately into details/GH_a and into the page footer.

-LB

 

[LucasH]

I was responding to you lbass. Thanks for the help. i will see how that goes...

 

[LucasH]

lbass

so i am creating 2 formulas, then placing them in the appropriate sections, correct?

Then the format formula for GH_b is in teh suppression formula, correct?

 

[LucasH]

lbass,

Ok that worked thank you very much. The only minor issue is that the page footer that was suppressed successfully, is still taking up room on the bottom of the page.

In other words, my terms (which are exactly one page long) are wrapping to another page leaving space (the same size of the suppressed page footer) on the bottom of the first page of terms.

Any idea around that?

 

[lbass]

Conditional page footers reserve space for the page footer when it appears, so you won't be able to get it to disappear unless you use a rather complex workaround that is described in Ken Hamady's most recent "Crystal Reports Underground News". It involves suppressing the actual page footer and creating a conditional page footer using a detail_b section, and counting the number of lines on a page to suppress all but the last one, which is formatted to print at the bottom of the page. If a suppression formula meets the conditional criteria, this detail_b section will disappear altogether.

To keep this simple, I would instead consider reducing the font size in the terms and conditions, and resizing the group footer.

-LB

 

[LucasH]

LB-

Can you set the Page Footer to Can Grow? I am not seeing that as available? If I can shrink it down to a small size and only have it grow when it's not suppressed, that should work for me.....I think. What a nightmare.

 

[lbass]

No, I don't think so. Why not just use the smaller font? Or change the margins to accommodate a larger text box for the T&C?

-LB

 

[LucasH]

The terms are 3 pages long . I didn't mention that before. I think my next idea is to move the existing page footer data (po totals and such) to a group footer and just tell the client that it will only show at the end of the po. The T & C's will then go in the page footer just fine. What a joke.

 

[lbass]

I think I'm missing the point. You wanted to suppress the page footer on the pages which show the T&C, right? What is displaying incorrectly???

-LB

 

[LucasH]

The problem is that the existing page footers (3 sections of them) are still holding their space in the report when I suppress them, so the 3 pages of T & C's are wrapping to 3.5 pages and leaving about 1/5 of each page blank (where the suppressed page footers are). It looks like crap.

 

[IdoMillet]

Consider a 3rd-party Crystal reports tool as a solution. There's at least 1 report manager among those listed at

http://www.kenhamady.com/bookmarks.html

that can solve this problem by automating the process of merging the bursting output from the report (1 pdf file for each PO) with a terms and conditions pdf file (and then, optionally also email the file to the appropriate customer).

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[LucasH]

This report is called by the accounting software which creats runtime tables that aren't accessible outside of the software.

Can your bursting output still be incorporated?