Let me begin by saying thank you for all your help. This is a great forum!
Here is my new problem.
These are the fields:
{Audit_Trail.FieldName}
{Audit_Trail.AfterValue}
{Audit_Trail.BeforeValue}
{Audit_Trail.DateStamp}
In the report it shows this:
Field Name: Temporary_Out
Before Value: 0
After: 1
Date: 02/04/2010
Then when inmate comes back:
Field Name: Temporary_Out
Before Value: 1
After: 0
Date: 02/08/2010
If I do a (date parameter) of say 02/06/10 I do not want the inmate to show in the report. But if I do a date parameter of 02/09/10 I want to see him. And there are multiple other Temporary_Out ‘s for the inmate. So let’s say the inmate has not come back in yet there will not be a Temporary_Out listed yet, until he is back in then the value will change from 1 back to 0.
How do I create a formula to suppress this type of inmate but show all others that do not have the Field Temporary_Out?
The formula that I was working on was something like this:
if {Audit_Trail.FieldName} = "Temporary_Out"
and {Audit_Trail.AfterValue} = "1"
and {Audit_Trail.DateStamp} <= {?date}
then 1 else 0
But I get all the other Temporary_Out <= {?date} and the inmate that is out has nothing. I can’t figure this out. There has to be something with an in between or something with the dates.
Thanks for the help in advance.
IP Logged
