VSys One: Volunteer Management Software

Previous Topic

Next Topic

Book Contents

Book Index

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

Blank when zero

If the field's value is blank, display nothing instead of an empty date.

bz

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

Blank when zero

If the field's value is blank, display nothing instead of an empty time.

bz

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

Time duration (tight)

 

dur:tight

Time duration (tight w/seconds)

 

dur:tight:ss

Blank when zero

If the field's value is blank, display nothing instead of an empty date.

bz

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

See Also

Report Designer

Report Groupings

Labels and Fields

Subreports