Databases Reference
In-Depth Information
■
Note
There is typically no need to format date columns in a report unless you want something other than the
standard format that you have set at the application level. You do always set the Application Date Format and
Application Timestamp Format under Edit Application Properties > Globalization (see Figure 13-2), don't you?
Figure 13-2.
Edit Application, Globalization settings
From within Report Attributes, I will
•
Set
PRODUCT ID
and
CATEGORY ID
to 'Display Text As' hidden
•
Update the following column headings:
•
PRODUCT_NAME to Name
•
PRODUCT_DESC to Description
•
AVAILABLE_YN to Available?
Within Column Attributes, I will also apply a Number/Date Format to
PRICE
of
FML999G999G999G999G990D00
, nicely displayed in the list of values as $5,234.10, and I will apply the
SINCE
format to my additional date columns. This will then display the time in relation to the current time (e.g.,
4 hours ago). Last, for now, I will center the value for Available? (
Column Alignment = center
). I like to
have this sort of Boolean data centered, but you can follow whatever standards make sense to you and,
most importantly, to your users. The revisions are shown in Figure 13-3.