Here is my problem? I would like to make a report that removes a couple of records. Here is what I have.
{Inmate Name} {Audit_Trail.AfterValue}
{@EMP}
{Audit_Trail.AfterValue} is a text field with mutilpe different entrys
{@EMP} is a formula that returns a true/false of {Audit_Trail.AfterValue} = "EMP"
So in the Detail Field there are mutiple false and only a couple inmates will have a true for the
{@EMP} field. But they will also have false fields as not all the {Audit_Trail.AfterValue} = "EMP".
When I either suppress the true fields it still leaves me all the inmates other records. I would like this to be gone.
If the {Inmate Name} has any "EMP" I do not want it to show.
Please help me. I am beating my head on the desk.
IP Logged
