I am trying to supress the details section if a field is repeated. I found the previous funtion and I am trying to use it to test the values. It appears to be working, except that it is testing for all values and not for just the group.
eg:
group by Client ID
detail : (randomfield1)
here is the code I am using for the suppresion
isNull (randomfield1)
or
(Previous (randomfield1)= (randomfield1)
and {Client.ID} = {Client.ID})
I am trying to test that the field is not empty (if it is, then supress the details) and that the field is not duplicated ( per client ID) . If it is duplicated, I want to supress it.
The issue is that if ClientID 1 . randomfield1 = ClientID2. randomfield1 then ClientID2. randomfield1 is suppressed ( which I don't want).
Any suggestions or tips?
IP Logged
