I'm a newbie using crystal reports and I need help creating a formula that will show all the releases orders when there is more than one of them. The task is asking me to add a new group and will need to create a conditional count formula for it. Basically, I have created a customer order report where there are OrderNum, OrderLine, PartNum, Calc_LineDesc, OrderQty, Unit Price etc..I've made 2 groups, one for customer_id and the other one is for OrderLine. I've also created a subreport for all the order releases in a particular order and put this under the Calc_Linedesc which only shows the OrderRelNum, ReqDate and SellingReqQty.

 

1: I need to only show releases when there is more than one of them

2: I need to stop details in "section b" from showing AT ALL, if there is only one release.

 

The problem is I don't know how to start and where to go.

 

The hint says that in order to do it I need an additional group added for OrderLine and then the conditional count formula.

 

Please help, this just an excercise for me but I'm struggling already.

 

Thanks in advance!!

You don't have to do the whole if/then statement.  You can do this with just:

 

 

This formula evaluates to True or False so you don't have to include the extra processing overhead of the If statement.

[/soapbox]

 

-Dell

supression is sort of backward try to reverse it