Skip to Content
0
Mar 20, 2015 at 02:18 PM

Array of 3 fields Affecting another Array...

19 Views

I need to build an array of 3 fields that are linked by another field. My fields are "UPCNOTE", "UPCDATETIME", "UPCEMPLOYEE". There will be multiple values for the 3 fields, linked by "UPCJOBID" to another field in a different table.

I have tried to build this array, however when I place it into my report it creates erroneous values in another array that is on the report creating duplicate values.

Even if I drop only the "UPCNOTE" field in the group footer on the report (field on far right in 2nd pic), it too causes the duplicate values in the "remaining ops" array. I do not know what is causing this is and am looking for guidance. Thanks!

This is the "Remaining Ops" array (in group footer) before I drop the "UPCNOTE" field on the report:


This is the "Remaining Ops" array (in group footer) after I drop the "UPCNOTE" field on the report:

Attachments

array prior.jpg (114.7 kB)
array error.jpg (77.8 kB)