I'm attempting to create a global string variable in a formula that I place in a group section, assigning it a meaningless value such as space, and then in the detail section, assign it a value of itself followed by an itemID, then comma. The idea is to create a comma-delimited string of values to which I can compare separate itemID's in the detail section of a subreport. (If I need to use an array instead, I'll tackle that. In the meantime, I haven't succeeded in assigning a value in the detail section.)
I was able to declare the variable:
Global StringVar IDlist := ","
but I can't get the correct syntax, or there is some other problem, when I try to assign any value to the variable in a separate formula just for that purpose in the detail section:
IDlist := "hello"
When I try to save the formula, the whole formula becomes highlighted and the error message is "The remaining text does not appear to be part of the formula."
The ultimate goal is to concatenate values each time a detail record is processed, like this:
IDlist = ID_list + {@ITEM_ID} + ","
I was able to declare the variable:
Global StringVar IDlist := ","
but I can't get the correct syntax, or there is some other problem, when I try to assign any value to the variable in a separate formula just for that purpose in the detail section:
IDlist := "hello"
When I try to save the formula, the whole formula becomes highlighted and the error message is "The remaining text does not appear to be part of the formula."
The ultimate goal is to concatenate values each time a detail record is processed, like this:
IDlist = ID_list + {@ITEM_ID} + ","