Bruce,

Be sure to place a Variable Memo object on the report, with "Suppress Empty Lines" enabled from the right click context menu.

The variable should be a NOTE data type, which combines the various TEXT strings.

An example is detailed within the Line Compression page in the R:BASE Tutorial:
https://www.rbase.com/support/rtutorial/linecompression.html

Very Best R:egards,
 
Razzak
On 01/21/2024 8:31 PM EST Bruce Chitiea <rby...@safesectors.com> wrote:
 
 
All:
I need to concatenate mailing addresses with variable line counts, for envelope printing. For example:
 
Addressee
StreetAddress
CityStateZip
or:
Addressee
Department
Corporation
StreetAddress
CityStateZip
 
A Report Variable is placed within the Page Header of a table-bound Report to serve as the printing breakpoint.
 
Simplified to focus just on line feeding[1] (ignoring the IFNULLing required for variable line counts), the variable:
 
( Addressee + (CHAR(013)) + Department + (CHAR(013)) + Corporation + (CHAR(013)) + StreetAddress + (CHAR(013)) + CityStateZip )
 
... produces this string, exactly where the address should be, one per envelope:
 
AddresseeStreetAddressCityStateZip
or:
AddresseeDepartmentCorporationStreetAddressCityStateZip
 
 
 
 
Thoughts? And thanks.
 
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203
 
(909) 238-9012 m

[1] This has also been attempted with (CHAR(013)) + (CHAR(010)) . No change.
 
 
 

 

--
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em27004548-d51a-4171-a2b2-7304a415578b%40daaf866b.com.

--
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1414058286.1337560.1705958361599%40email.ionos.com.

Reply via email to