... with a little reformatting:
vBillingDetails (NOTE):
(
BillToCompany + (CHAR(013)) + +
BillToAddress1 + (CHAR(013)) + +
BillToAddress2 + (CHAR(013)) + +
( BillToCity + ',' & BillToState & BillToZip ) + (CHAR(013)) + +
( IFNULL(BillToPhone , NULL , 'Phone:' & BillToPhone)) + (CHAR(013)) +
+
( IFNULL(BillToFax , NULL , 'Fax:' & BillToFax)) + (CHAR(013)) +
+
( IFNULL(BillToEMail , NULL , 'E-Mail:' & BillToEMail))
)
vShippingDetails (NOTE):
(
ShipToCompany + (CHAR(013)) + +
ShipToAddress1 + (CHAR(013)) + +
ShipToAddress2 + (CHAR(013)) + +
( ShipToCity + ',' & ShipToState & ShipToZip ) + (CHAR(013)) + +
( IFNULL(ShipToPhone , NULL , 'Phone:' & ShipToPhone)) + (CHAR(013)) +
+
( IFNULL(ShipToFax , NULL , 'Fax:' & ShipToFax)) + (CHAR(013)) +
+
( IFNULL(ShipToEMail , NULL , 'E-Mail:' & ShipToEMail))
)
------ Original Message ------
Sent: 4/7/2016 10:10:23 AM
Subject: [RBASE-L] - Sample Applications: Using the Suppress Empty Lines
Option in Reports
From: "A. Razzak Memon" <[email protected]>
To: [email protected]
Cc:
Thursday, April 7, 2016
To R:BASE Community:
A sample application "Using the Suppress Empty Lines in Reports" is now
available for
both R:BASE eXtreme 9.5 (32/64) and R:BASE X and R:BASE X Enterprise
versions.
Sample Applications: http://www.razzak.com/sampleapplications
Application Titles:
. Using the Suppress Empty Lines Option in Reports - R:BASE Extreme 9.5
(32/64)
. Using the Suppress Empty Lines Option in Reports - R:BASE X and R:BASE
X Enterprise
Database Name: Address
Table Name...: Addresses
Report Name..: Addresses
Report Expressions:
vBillingDetails (NOTE):
(BillToCompany+(CHAR(013))+BillToAddress1+(CHAR(013))+BillToAddress2+(CHAR(013))+(BillToCity+','&BillToState&BillToZip)+(CHAR(013))+(IFNULL(BillToPhone,NULL,'Phone:'&BillToPhone))+(CHAR(013))+(IFNULL(BillToFax,NULL,'Fax:'&BillToFax))+(CHAR(013))+(IFNULL(BillToEMail,NULL,'E-Mail:'&BillToEMail)))
vShippingDetails (NOTE):
(ShipToCompany+(CHAR(013))+ShipToAddress1+(CHAR(013))+ShipToAddress2+(CHAR(013))+(ShipToCity+','&ShipToState&ShipToZip)+(CHAR(013))+(IFNULL(ShipToPhone,NULL,'Phone:'&ShipToPhone))+(CHAR(013))+(IFNULL(ShipToFax,NULL,'Fax:'&ShipToFax))+(CHAR(013))+(IFNULL(ShipToEMail,NULL,'E-Mail:'&ShipToEMail)))
Report Controls: Variable Memo with "Suppress Empty Lines" option
checked.
Here is a sample report for your viewing pleasure ...
http://www.razzak.com/tips/SuppressEmptyLinesInReports.pdf
. Notice the difference in record detail item 7, 18, 27, and 30.
. Notice the formulation and the presentation of string when there is a
phone number, fax number, and e-mail address (record detail item 27)
Enjoy the presentation!
Very Best R:egards,
Razzak.
-- 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 post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/201604071710.u37HAhwB010579%40atl4mhob09.myregisteredsite.com.
For more options, visit https://groups.google.com/d/optout.
--
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 post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/emdb9af93e-a82a-4165-9061-76c5421aa7de%40ssi-pathfinder.
For more options, visit https://groups.google.com/d/optout.
