Crystal Report Formula - Need Help

[Former Member]

Hello Experts,

One of our customer does rental business and they use a third party add-on. People can rent tents, linens, kitchen items and so on.

Here is my requirement:

We need to print Rental Terms and Conditions ( almost a page) for all rental orders.

If there is a tent item on the order we also need to print Tent Terms( almost a page) along with general rental terms .

Current status:

If there is only tent items on the order, crystal reprots prints both pages ( tent, rental terms which is ok)

If there are tent and other items ( add-on does not print tent terms) I am using item group in the formula

{VW_RentalOrder.ItmsGrpCod}!=103

( where items does not belong to Tent)

Please help me.

[Former Member]

Where do you have this formula - as a suppress formula on a page / report footer?

[Former Member]

Hello Julie,

I have the rental terms in Report Footer B and Tent Terms in Report Footer C. The formula exists in Report Footer C.

[Former Member]

So you want this to print only if there are tent items included in the order?

Maybe try a running total to count where item group = 103, then use the running total to suppress if = 0?

[Former Member]

Yes, I want to print tent terms only if atleast one tent items exists on the line.

Your advise sounds like an interesting one, i will try now.