Problems using formula to supress data

[Jonesxx]

Hi,

I'm using Crystal 8.5. I am having a problem when trying to supress a field using a formula.

The table name is Sales and the field is ref {Sales.Ref) when I right click on the field and go to format field, the format editor screen opens, I go into the supress formula icon and enter the following {Sales.REF} = 'Client'

So basically I am saying supress any data in the reference field where the reference is equal to client. However the result I am getting, is that ALL data in the reference field is being supressed whether it has client in it or not. I need all other data where client has not been entered into the reference field to be displayed on the report.

Please help

Thanks v m

 

[lbass]

First, do not use a checkmark in the suppress area in addition to using a conditional formula. If your formula result is null, the suppression will default to the checkmark, suppressing all if checked, or none if not checked.

Do you mean that the result of {sales.ref} is a string that says "Client"? If so, there might be spaces or perhaps there is case sensitivity. Try:

uppercase(trim({table.ref})) = "CLIENT"

-LB

 

[Jonesxx]

Hi Ibass,

I've tried what you have suggested but it has not made any difference the field is still being supressed.

Yes you are correct the string does say 'Client' there are not any blanks as the entry for 'Client'is automatically generated by the system itself. Also the check mark in the supress area has never been ticked, I always leave it unticked.

Any ideas?

Thanks

 

[Jonesxx]

Also, it would probably be useful to know that the report has been grouped by {Sales.status}. The desired out come would be something like:

'Status' field: Totals:
Client 3
Potential clients 5
Cold Clients 7

In the above example the Clients which are being displayed do NOT have the word 'Client' in the reference field {Sales.ref}, only clients without the string 'Client' in the {Sales.ref} table should be displayed in the report.

I hope this helps

 

[lbass]

I can't think of why the previous suggestion wouldn't work.

I think you need to place your {sales.ref} field in the detail section without any suppression and observe what it returns. Please report back with sample data. You should also add the status field as well to see how they work together.

What is your record selection formula? Do you have more than one table? How are they joined?

-LB