I do this by getting my multiple values and loading them into a var before I
go into the report. This code assumes your value is 10 chars wide. You could
do something like this:
set var vextra text=null
set var vtemp text = null
set var vi int = 1
set var sqlcode = 0
label get_next
select some_col into vtemp from whatever where indexcol = .vindex_col and
count = .vtemp
if sqlcode <> 100 then
if vextra is not null then
set var vextra = (.vextra + (char(255)))
endif
set var vextra = (.vextra & (ljs(.vtemp,10)))
set var vi = (.vi + 1)
goto get_next
endif
print myreport where .......
You want to place the var vextra on the report and make it 11 characters wide
and let it expand. This will wrap everything in nice rows.
Troy Sosamon
>===== Original Message From [EMAIL PROTECTED] =====
>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
>>
Troy Sosamon
Denver Co
[EMAIL PROTECTED]
