Razzak, thank you.

I just knew I had to be working too hard; but learned a lot along the way.

Maybe it's time to revisit the tutorial. Been a while.

The very best, Bruce.

Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203

[email protected]
(909) 238-9012 m

------ Original Message ------
From "Razzak Memon" <[email protected]>
To [email protected]
Date 1/22/2024 1:19:21 PM
Subject Re: [RBASE-L] - Mailing Address Line Feed Fail

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 <[email protected]> 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

[email protected]
(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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em27004548-d51a-4171-a2b2-7304a415578b%40daaf866b.com <https://groups.google.com/d/msgid/rbase-l/em27004548-d51a-4171-a2b2-7304a415578b%40daaf866b.com?utm_medium=email&utm_source=footer>.

--
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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1414058286.1337560.1705958361599%40email.ionos.com <https://groups.google.com/d/msgid/rbase-l/1414058286.1337560.1705958361599%40email.ionos.com?utm_medium=email&utm_source=footer>.

--
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 [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/em80a79b3b-97fb-4286-a7da-f486ea061601%40daaf866b.com.

Reply via email to