Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: How To (Forms, Reports, and more) > Reports and Labels > Technical Documents

Using Report System Variables

Scroll Prev Top Next More

The System Variable control in the R:BASE Report Designer provides various options for system information to be displayed on a report.

 

In the Report Designer, click on System Variable control on the Variable Controls Toolbar, and add the object to the a report. Then, review the following drop-down options available in the Edit Toolbar.

 

System Variables

Description

Date

Current system date

Date Time

Current system date and time

Document Name

Name of the report

Print Date Time

Date and time the report was printed

Page Count

Total number pages in the break/report

Page Set

Current page number and total pages in break/report

Page Set Desc

Textual summary of page number and page count

Page No

Current page number

Page No Desc

Textual summary of current page number

Time

System time

R:BASE User

Current R:BASE User

Windows User

Current Windows User

Computer Name

Computer Name

Database Name

Database Name

Default Printer

Default Printer

Current Printer

Current Printer

Version

R:BASE Version

Build

R:BASE Build

Version Build

R:BASE Version and Build

Current Folder

Current Folder

 

 

You can control the appearance (Font, Alignment, etc.) of above System Variables at design-time by using the Format Toolbar of the Report Designer.

 

You can also set key properties by using the speed menu. To access the speed menu, position the mouse cursor over the System Variable object located on the report and then click the right mouse button.

 

Use the Display Format option to control how data is formatted for a report. For example, '#,0' would display 10000 as 10,000. If the data field is a DATE or TIME type, then you can use the standard formatting characters for those types ('mm/dd/yyyy', 'hhnnss').

 

From the Report Designer you can access the Display Format property by positioning the mouse cursor over the System Variable object located on report and then clicking the right mouse button. A speed menu containing the key properties for the component will be displayed. Select Display Format... from this menu. The Display Format dialog will be displayed.

 

Example of available Display Format options:

 

Date

Display

Format

3/4/02

m/d/yy

03/04/02

mm/dd/yy

03/04/2002

mm/dd/yyyy

4-Mar-02

d-mmm-yy

04-Mar-02

dd-mmm-yy

March 4, 2002

mmmm d, yyyy

3/4

m/d

Mar-02

mmm-yy

March-02

mmmm-yy

Monday, March 4, 2002

dddd, mmmm dd,yyyy

 

 

Document Name

Name of the report

 

Print Date Time

Display

Format

3/4/02 13055 PM

m/d/yy hnnss AM/PM

3/4/02 133055

m/d/yy hnnss

3/4/02

m/d/yy

03/04/2002

mm/dd/yyyy

4-Mar-02

d-mmm-yy

04-Mar-02

dd-mmm-yy

March 4, 2002

mmmm d, yyyy

3/4

m/d

Mar-02

mmm-yy

March-02

mmmm-yy

Monday, March 4, 2002

dddd, mmmm dd, yyyy

Monday, March 4, 2002 13055 PM

dddd, mmmm dd, yyyy hnnss AM/PM

 

 

Page Count

Display

Format

1

#,0;-#,0

 

 

Page Set

1 of 1

 

Page Set Desc

Page 1 of 1

               

Page No

Display

Format

1

#,0;-#,0

 

Page No Desc

Page 1

 

Time

Display

Format

130 PM

hnn AM/PM

1330

hnn

13055 PM

hnnss AM/PM

133055

hnnss

 

Other Formats

Display

Format

-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.4%

0 %

-1234.40%

0.00 %