VSys One: Volunteer Management Software

Display Formats

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, this is replaced in the report 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	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 %`

Number fields as duration

(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		`h: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`