I have a suppression formula in my Detail Section Expert... Suppress is not checked, but I have the following formula in under the formula button, which turned it red, and seems to suppress what I need while leaving what I want...
{table1.invoice}=previous({table1.invoice}) AND
{table1.vendor}=previous({table1.vendor})
The problem I am having is the Running Total field is still evaluating the suppressed records.
I've read all sorts of similar topics and what Google found for me, but none of that seems to work.
I've tried adding the above formula to the RT Evaluate Using a Formula option, but it's way off.
Any ideas would be appreciated.
I've found that the need for suppression is caused by the way one of the fields data is stored in one of the two databases I am accessing. When I removed that field, I can remove the suppression formula and all the RT fields are correct. I'm accessing a MSSQL DB and a Timberline (accounting) Pervasive DB. It's basically looping some data causing duplicates.
Again... I'm new to Crystal Reports and I need some help if anyone has some to offer here.
Thanks in advance!!!