I have two formulas which are used to concatenate the name and value fields. They will show all the values in their own fields separated by commas. These two fields are in my group footer #3 along with a bunch of other fields (IntID, Interval, etc.).
The issue I'm having is that if I have more than one IntID (unique) it will concatenate all my values. For example, let's say I have the following for IntID = 1 with table1.value being "1, 2, 3" For IntID = 2, table1.value will now have "1, 2, 3, 4, 5" when it should only have "4, 5". I tried resetting the the global variable table1.value (string value field) to blank by creating the formula and putting in the group header but that didn't seem to do anything.
Any help is greatly appreciated.
Thanks.
The issue I'm having is that if I have more than one IntID (unique) it will concatenate all my values. For example, let's say I have the following for IntID = 1 with table1.value being "1, 2, 3" For IntID = 2, table1.value will now have "1, 2, 3, 4, 5" when it should only have "4, 5". I tried resetting the the global variable table1.value (string value field) to blank by creating the formula and putting in the group header but that didn't seem to do anything.
Any help is greatly appreciated.
Thanks.