Search results for query: *

I used: ucase({table.field}) like "*DO NOT USE*" this worked perfectly. Thank you all for your responses. Eve

Hi This field is the name of the client. Some of the clients have been set up with 'clientname - DO NOT USE'. I want to suppress any clients with DO NOT USE from my report. Thanks Eve

Hi - sorry for not being more specific. I actually wanted to see something that 'contains', not 'does not contain'. I want to say: if {DNUCLEUS.NAME} contains "do not use" then Suppress Thanks for your help. Eve

Does anyone know how to create a formula to say 'Does not contain'?

That's great. Thank you for all your help.

Thanks for all your responses. Here's an example of what i am trying to do. My report shows all clients and different date types input for each client. There are 3 date types, ARD, IRD and LMD.I only want the report to show ARD & IRD dates. All clients should have a date type of "ARD", so I...

Is it possible to create a formula to say, if {Example} = "?" but <> "??" then etc... ?

Thank you for your help. If i elimiate the 0 balance records in the record selection formula, it then shows the previous balance, which is wrong as I only want the most recent balance. This seems to happen whatever I try...

Thank you for your help with this. The report is to show client bank accounts and total amounts held in each. I have used a suppression {LBALS.BDATE} <> {@MaxBalanceDate} to show only the most recent balance and not all the transactions. (The formula MaxBalanceDate is Maximum...

Is it possible to create a formula to add up only visable records in a report? I have supressed some records and want to add up only the amounts that are visable. When I add a summary, it adds all the amounts, whether they are supressed or not. Or is it possible to create a summary based only...

I've tried supressing the details section where the 0.00 balance is displaying, but this then shows all transactions including 0.00 balances. I think this could be because this section is also set to only show the maximum date balance? Any other suggestions gratefully received! Thanks

I have written a report to show bank balances of accounts. I only want to show the most recent transaction, therefore showing only the current balance and not all transactions. I have added a formula Maximum ({Date},{Account}) This works and displays only the latest balance based on the...

That works, Thanks!

Can anyone help with this formula. I am trying to create an Alert to show when a date is not present. eg if {date} = "" then "Alert"