Monday, August 12, 2002
From The Edge: Using System Variables in 7.0 Report Designer
Section: Report Designer
Chapter: Running R:BASE Your Way!
Platform: R:BASE 7.0 for Windows
Build: 1.855xRT03 and Higher
System Variable option of R:BASE 7.0 for Windows Report Designer provide
various options and what type of report information is printed in the report.
From the Report Designer, click on System Variable to locate the following
options available in the drop-down combo-box on the far left of the Edit Bar.
System Variables:
. 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
You can control the appearance (Font, Alignment, etc.) of above System
Variables at design-time by using the Format Bar 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', 'hh:nn:ss').
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.
Available Display Format Options (Examples):
Date:
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
Date Time
3/4/02 1:30:55 PM m/d/yy h:nn:ss AM/PM
3/4/02 13:30:55 m/d/yy h:nn:ss
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 1:30:55 PM dddd, mmmm dd, yyyy h:nn:ss AM/PM
Document Name: Name of the report
Print Date Time:
3/4/02 1:30:55 PM m/d/yy h:nn:ss AM/PM
3/4/02 13:30:55 m/d/yy h:nn:ss
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 1:30:55 PM dddd, mmmm dd, yyyy h:nn:ss AM/PM
Page Count:
1 #,0;-#,0
Page Set: 1 of 1
Page Set Desc: Page 1 of 1
Page No:
1 #,0;-#,0
Page No Desc: Page 1
Time:
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
Other Formats:
-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 %
PDF version of this technical document is also available at:
From The Edge: http://www.razzak.com/fte (Reports and Labels)
(Powered by R:Tango)
Enjoy and make sure to have fun!
Very Best Regards,
Razzak.
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
