|
|
|
|
|
Within the Report Designer, and in Custom Column reports, you can specify a display format for various fields. The formats available vary by field and data type.
Special format prefix codes
Use these to simplify the display of prefixes on fields in reports.
Format |
Code |
& |
When used at the beginning of any display format, is replaced in the report when run with the name of the field plus a colon (:), but only if the field's value is not blank. |
~xxxx~ |
When used at the beginning of any display format, the text between the tildes is displayed at the beginning of the field when printed, but only if the field's value is not blank. |
For example, the display format "&" when used on a person's Date started field will display
Date started: 01/12/2010
if there is information in the field. If the field is blank nothing will display. This removes extraneous and confusing labels from the report.
Number fields
Format |
Description |
Code |
-1,234 |
|
#,0;-#,0 |
-1,234.40 |
|
#,0.00;-#,0.00 |
(1,234.40) |
|
#,0.00;(#,0.00) |
($1,234.40) |
|
$#,0.00;($#,0.00) |
-$1,234.40 |
|
$#,0.00;-$#,0.00 |
-$1,234 |
|
$#,0;-$#,0 |
($1,234) |
|
$#,0;($#,0) |
-1234 % |
|
0 % |
-1234.40 % |
|
0.00 % |
|
|
|
(all "time duration" options take a number field and consider it to be a duration, stored in hours) |
||
Time duration (system setting) |
Uses the user-defined display option for durations, usually hours:minutes or fractional hours (hh.dd). |
dur:sys |
Time duration (system setting with seconds) |
As above, but includes seconds. |
dur:sys:ss |
Time duration (decimal) |
Always displays as fractional hours, e.g. "14.75". |
dur:dd |
Time duration (hh:mm) |
Always displays as hours:minutes, e.g. "14:45". |
dur:hh:mm |
Time duration (hh:mm:ss) |
As above, but with seconds included. |
dur:hh:mm:ss |
Date fields
Format |
Description |
Code |
3/4/95 |
|
m/d/y |
03/04/95 |
|
mm/dd/yy |
03/04/1995 |
|
mm/dd/yyyy |
4-Mar-95 |
|
d-mmm-yy |
04-Mar-95 |
|
dd-mmm-yy |
March 4, 1995 |
|
mmmm d, yyyy |
3/4 |
|
m/d |
Mar-95 |
|
mmm-yy |
March-95 |
|
mmmm-yy |
System setting |
The date in the user-defined date format. |
sys |
System setting, just date |
As above, but removes any time elements. |
sys:date |
Time fields
Format |
Description |
Code |
1:30 PM |
|
hh:nn AM/PM |
13:30 |
|
h:nn |
1:30:55 PM |
|
h:nn:ss AM/PM |
13:30:55 |
|
h:nn:ss |
System setting |
Time in the user-defined time format. |
sys |
System setting, with seconds |
As above, but including seconds. |
sys:ss |
Tight |
Time in the smallest space possible, e.g. "Noon", "Midnight", "9am", "9:45pm". |
tight |
Tight, with seconds |
As above, but including seconds. |
tight:ss |
Time duration (system setting) |
Time as a duration in the user-defined duration format. |
dur |
Time duration (system setting, with seconds) |
As above, but including seconds. |
dur:ss |
Time duration (decimal) |
Time as a duration in decimal form, regardless of user-defined duration format. |
dur:dd |
Time duration (hh:mm) |
Time as a duration in hh:mm form, regardless of user-defined duration format. |
dur:hh:mm |
Time duration (hh:mm:ss) |
As above, but including seconds. |
dur:hh:mm:ss |
Date/time fields
Format |
Description |
Code |
3/4/95 1:30:55 PM |
|
m/d/yy h:nn:ss AM/PM |
3/4/95 13:30:55 |
|
m/d/yy h:nn:ss |
3/4/95 |
|
m/d/yy |
03/04/95 |
|
mm/dd/yy |
03/04/1995 |
|
mm/dd/yyyy |
4-Mar-95 |
|
d-mmm-yy |
04-Mar-95 |
|
dd-mmm-yy |
March 4, 1995 |
|
mmmm d, yyyy |
3/4 |
|
m/d |
Mar-95 |
|
mmm-yy |
March-95 |
|
mmmm-yy |
System setting |
Date/time in the user-defined format. |
sys |
System setting, just date |
As above, but excluding any time elements. |
sys:date |
System setting, just time |
User-defined date/time format but without the date. |
sys:time |
System setting, just time with seconds |
As above, but including seconds. |
sys:time:ss |
System setting with seconds |
Date/time in user-defined format, but including seconds. |
sys:ss |
Friendly |
For dates in the past three days, shows, e.g. "(yesterday)", "2 days ago", otherwise uses the user-defined date format. |
fr |
Friendly with seconds |
As above, but including seconds. |
fr:ss |
Tight |
See "Tight" under "Time fields", but with the date included at the beginning. |
tight |
Tight, just time |
See "Tight, just time" under "Time fields", but with the date included at the beginning. |
tight:time |
Tight, just time with seconds |
See "Tight, just time with seconds" under "Time fields", but with the date included at the beginning. |
tight:time:ss |
Time duration (system setting) |
Time as a duration in the user-defined duration format. |
dur |
Time duration (system setting, with seconds) |
As above, but including seconds. |
dur:ss |
Time duration (decimal) |
Time as a duration in decimal form, regardless of user-defined duration format. |
dur:dd |
Time duration (hh:mm) |
Time as a duration in hh:mm form, regardless of user-defined duration format. |
dur:hh:mm |
Time duration (hh:mm:ss) |
As above, but including seconds. |
dur:hh:mm:ss |
Boolean/checkbox/yes no fields
Checked/true value |
Un-checked/false value |
Code |
Yes |
No |
Yes;No |
Y |
N |
Y;N |
True |
False |
True;False |
T |
F |
T;F |
OK |
|
OK; |
Done |
|
Done; |
|
Not OK |
;Not OK |
|
Not Done |
;Not Done |