Re: Wrap functionality question

[Don Barclay <don.barclay@SRS.GOV>]

Poonam,
I can't reproduce your error.  I noticed you are missing an equals sign on
the line that you are setting #begin_from - but that shouldn't be causing
your problem.

Don Barclay
Westinghouse Savannah River Co.
Aiken, SC 29860




Poonam Auluck <poonam.auluck@AMS.COM>
Sent by: "Discussion of SQR, Brio Software's database reporting language"
<SQR-USERS@list.iex.net>


07/23/2002 07:14 PM
Please respond to sqr-users


        To:     SQR-USERS@list.iex.net
        cc:
        Subject:        Re: Wrap functionality question


Hi All -

I take my previous email back.  :o(  While I was able to get my remarks
working correctly, I was unable to get my addresses to print out correctly
using the same logic.  I used Don's suggestion of adding the wrapped rows
to my #begin-row.  When I compile the code below, I get an SQR error
stating "The value for 'wrapdepth' (0) must be > 0."

Any suggestions what this means and/or how to fix it?  First of all, I
can't imagine it not being greater than 0 because the line will definitely
have to wrap.
Here's my code...any suggestions how to fix this problem??


begin-procedure get_from_address
let #begin_from = 82
begin-select
b.addr_nm               &from_addr_nm
b.addr_l1                 &from_addr_l1
b.addr_l2                 &from_addr_l2
b.addr_l3                 &from_addr_l3
b.addr_l4                 &from_addr_l4
b.addr_l5                 &from_addr_l5
b.addr_city              &from_addr_city
b.addr_stae            &from_addr_stae
b.addr_zpcd           &from_addr_zpcd
from mf_pr_amd a, mf_offc_doc_jn b
where a.uidy = b.parn_id
and a.doc_num = $input_doc_num
and b.offc_typ = 'I'
end-select
string &from_addr_l1 ' ' &from_addr_l2 ' ' &from_addr_l3 by '' into
$from_address_one
string &from_addr_city ', ' &from_addr_stae ' ' &from_addr_zpcd by '' into
$from_address_two
print &from_addr_nm (72,285)
print $from_address_one (#begin_from, 285) wrap 50 5 line-height=10
let #begin_from #begin_from + (wrapdepth($from_address_one,50,1,'','') *
10)
print $from_address_two (#begin_from, 285) wrap 50 5 line-height=10
end-procedure !ends get_from_address

Thanks for the help!!  It's is all greatly appreciated.
Poonam Auluck