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.
