I have a column {@IF } that is based on a formula. It produces the following CnBiosName (formula created column) John Not Paid Paul Paid Ringo Paid Ben Rothlisberger Paid George Paid I would like a count of how many "Paids" and "Not Paids" Thanks so very much! Bryce

Greetings All, It is easy enough to use IF in this manner: If {CnGf_1Note_1.CnGf_1Note_1_Actual_Notes} = "Host Committee 2008 - Gala" Then "Host" Else " " But what function could be used to see if the field contatins "Host" rather than equals? I need this to be...

I have a formula(Basic Sal) in my report to calculate basic salary of each employee.The formula is as below Maximum ({PMS_EmpBasicPay.Amount},{PMS_Employee.Name} ) I need to find the total basic/grand total of basic salaryin the page footer.How do I sum my formula field(Basic sal)??

Hello, My colleague and I are revising a good Crystal Report - Our source data contains duplicates (for a variety of reasons, which we're not planning to address right now). (Before this, we've been manually de-duping the Access database...no comments please!) Thus we're needing to write...