Conditional Section formula

[S2art7]

I would like to print or suppress text at the end of a report based on the Customer Number field in the main report. If it has to be in a Page footer then it needs to print only on the last page. I am new to Crystal any help would be much appreciated.

 

[lbass]

Place the text in the report footer to have it appear only at the end of the report. To suppress the text for certain customer numbers, go into the section expert->report footer->suppress->x+2 and enter a formula like this:

{table.customernumber} in [123,465,789]

-LB

 

[S2art7]

My apologies. My first post was poorly worded and not very well thought out. I agree that it should be a report footer and your formula works great but here's what I really need to do.
I have a customer list of around 2000. Currently 3 of these (this number may grow over time) are requiring that a Letter of Conformance accompany all Shipping Documents (existing crystal forms). Each customer's letter is different so I have conformance letters CL1, CL2 and CL3.
I am trying to print the appropriate letter on the page footer for only those 3 customers.
In this case do in need 3 different report footers each with its own suppression formula and letter version or can I use a nested if statement to pull the correct version into the same footer? Something like:
IF {table.CustomerNo}= "111" THEN CL1 ELSE
IF {table.CustomerNo}= "222" THEN CL2 ELSE
CL3
Thanks for your patience.

 

[lbass]

Are you running the report for multiple customers at a time and grouping on the customer? If so, I would insert additional group footer sections b, c, d, etc. Place each letter in one section, and then conditionally suppress each section with a formula, e.g.:

{table.customerNo}<>'111'

-LB

 

[S2art7]

Thanks that sounds like the best solution.