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