Dan,
Don't print anything in the detail section, print in the footer section, e.g.
F1 (although in your report, it may be F2 or F3, because you may have
other uses for F1, etc.)
Create a variables like this:
rvTrackList TEXT = (IFNULL(.rvTrackList, tracking_number, (.rvTrackList
& tracking_number)))
You will have to explicitly type the TEXT datatype when you define it,
since it refers to itself.
Locate the variable in the F1 section (or F2, whatever you need.)
Create your #1 (or whatever) breakpoint on the column invoicenum, and
reset the variable rvTrackList at that breakpoint.
Bill
On Thu, 30 Aug 2001 12:55:52 -0700, Dan Goldberg wrote:
>I am trying to put multiple rows of data from one table into a report
variable of another table.
>
>sample data
>
>invoicenum tracking_number
>---------------- -----------------------
>12345 509-588956
>12345 509-589654
>12345 508-649710
>
