Skip to Content
0
Former Member
Jul 23, 2009 at 05:19 PM

Outputting the contents of arrays to the report

20 Views

During the detail processing, I accumulate data into a set of arrays. At total time, I want to output the contents to the report, displaying each array element on a separate line of the output. The number of elements in the array varies from 0 to 100, meaning the output will take up 0 to 100 lines of the report. Ideally, I'd create a single formula which loops through the array, outputting a line for each array element, but I can find no way for a formula to cause output other than by ending with a return value. In fact, I can't find any way to output multiple lines, other than creating a formula for each possible array element, placing each formula in a separate section, and suppressing the output line if blank. This is terribly cumbersome and crude. Surely there's a better way!