I have details from another table already printing in the detail section.
What I have is like:
[PAGE HEADER]
customername
customeraddress
invoicenumber
[DETAIL]
qty_ordered
item_description
[PAGE FOOTER]
trackingnumbers(variable which is rows of a column in a different table)
I am trying in a way to do multiple details but I am putting one of the
detail sections into a variable.
Dan
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Bill Downall
Sent: Thursday, August 30, 2001 1:16 PM
To: [EMAIL PROTECTED]
Subject: Re: PUTTING MULTIPLE ROWS OF A COLUMN INTO A REPORT VARIABLE
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
>
