Very timely for me, too. Thanks!
Question: Variables are created as NOTE. Could/should these just as
easily be VARCHAR? Preference?
Bruce
SafeSectors, Inc.
909.238.9012 mobile
------ 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/em67b548e0-8413-4bef-8f2c-87d0b30f22cb%40ssi-pathfinder.
For more options, visit https://groups.google.com/d/optout.
