Include a duplicate 'violation' in a group

I'm trying to add the following condition to the excisting formula : (previous solution)

I am trying to show if a grouped  userIDTag has a duplicate movement (entry) which will show as a 0 in the system - please see image.

I am thinking that : Include if true
({ContractParkersMovement.UserIDTag},{ContractParkersMovement.MovementType}) <> 
 next ({ContractParkersMovement.UserIDTag},{ContractParkersMovement.MovementType}

should do this but keep getting a error with the formula. Violation Condition
I am grouping with "UserIdTag" which is already functioning and setup in group selct and want to add the above condition : If a user with the same tagID (They have multiple cards issued to them) has 2  entry's (shown as a 0 for movement type ) to also include else just not show. Violation Condition
John-S PretoriusTechnical Service Manager, Mid-AtlanticAsked:
Who is Participating?
 
mlmccCommented:
The only way to do this is to use suppression and probably a subreport since you won't know when the group starts if you need to suppress.

Is the total number of 0s at all helpful?

mlmcc
0
 
mlmccCommented:
You have to use just a single field and you can't select on it because NEXT and PREVIOUS are orinttime functions which is the final pass after all selection is done.

You can't use NEXT within a group setting.  
Test

Next({ContractParkersMovement.UserIDTag}) <> {ContractParkersMovement.UserIDTag}
AND
{ContractParkersMovement.MovementType} <>  next ({ContractParkersMovement.MovementType})

mlmcc

0
 
John-S PretoriusTechnical Service Manager, Mid-AtlanticAuthor Commented:
I get  "The formula cannot be used because it must be evaluated later"

Please see attatched report - the second one is the only user that is a violation 115694 because he came in twice in a row - movement - '0'  

The first and last I can get rid of in the group statement

 QCS-Users-Violation-Report.rpt QCS-Users-Violation-Report.rpt
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
John-S PretoriusTechnical Service Manager, Mid-AtlanticAuthor Commented:
Yes - it is absolutely, all we have to is find a way to 'if' I have 2 0's after one another (2 Entry's) it means 1 User(same ID tag) has given one of his cards to someone else and the rule is if they have more than 1 card is that there cannot be more than on in the garage at the same time.
0
 
mlmccCommented:
Is the basic raw data as shown in the picture?

mlmcc
0
 
John-S PretoriusTechnical Service Manager, Mid-AtlanticAuthor Commented:
Yes, and I also attacthed a .rpt file with the data.
0
 
John-S PretoriusTechnical Service Manager, Mid-AtlanticAuthor Commented:
How would I calculate the sum of the first 2 transactions of each group ?

If I can do this in group selection : if sumoffirst 2 transaction = 0
0
 
John-S PretoriusTechnical Service Manager, Mid-AtlanticAuthor Commented:
This will be continued.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.