Monday, May 19, 2008 Tip of the Day: Capturing Report System Variables
Section: Report Properties Supported Versions: . R:BASE 7.6 for Windows (Build: 7.6.3.30516 or higher) . R:BASE C/S:I 7.6 for Windows (Build: 7.6.3.30516 or higher) . R:BASE Turbo V-8 for Windows (Build: 8.0.17.30516 or higher) The following System Variables are supported in Reports: . Date (Current Date) . Date Time (Current Date and Time) . Document Name (Report Name) . Print Data Time (Print Date and Time) . Page Count (Total page count such as 9) . Page Set (such as 1 of 9, 2 of 9) . Page Set with Description (such as Page 1 of 9, Page 2 of 9) . Page Number (such as 1, 2, 3, 4, 5, 6, 7, 8, 9) . Page Number with Description (such as Page 1, Page 2, Page 3) . Time (Current Time) Did you know that you can capture the value any of these System Variables using the GETPROPERTY command? Syntax: GETPROPERTY <ReportSystemVariableComponentID> TEXTVALUE varName All you need to do is assign a unique Component ID to a System Variable object placed on a report band and then use GETPROPERTY command to capture the value. In addition, you may also use the following GETPROPERTY commands to retrieve REPORT specific values. -- To Retrieve Report Name GETPROPERTY REPORT REPORT_NAME vReportName Report name may also be captured using the RBTI_REPORT_NAME variable. -- To Retrieve Total Number of Tables Associated with Report GETPROPERTY REPORT REPORT_TABLE_COUNT vReportTblCount -- To Retrieve the Name of Master Table GETPROPERTY REPORT 'REPORT_TABLE_NAME[0]' vReportMasterTbl Have fun implementing these GETPROPERTY options in your report! Very Best R:egards, Razzak.
