Friday, September 23, 2005
Tip of the Day #2: Retrieving Report Properties
Using the GETPROPERTY command in R:BASE 7.5 and V-8 Turbo for Windows,
you can also retrieve the following properties of a report.
. Report Name
. Associated Number of Tables
. Associated Names of Tables (Master/Slave)
(For Sub-Reports)
Example 01: (To Retrieve Report Name)
GETPROPERTY REPORT 'REPORT_NAME' vReportName
RETURN
Variable vReportName will return the name of the report.
Example 02: (To Retrieve the Number of Associated Tables in Report)
GETPROPERTY REPORT 'REPORT_TABLE_COUNT' vReportTableCount
RETURN
Variable vReportTableCount will return the total number of associated
tables in report.
Example 03: (To Retrieve the Name of Master Table Name for the Report)
GETPROPERTY REPORT 'REPORT_TABLE_NAME[0]' vReportMasterTable
RETURN
Variable vReportMasterTable will return the name of master table name for
the report.
Example 04: (To Retrieve the Name of First Slave Table Name for the Report)
GETPROPERTY REPORT 'REPORT_TABLE_NAME[1]' vReportSlaveTable1
RETURN
Variable vReportSlaveTable1 will return the name of first slave table
associated with a report in a Sub-Report environment.
Example 05: (To Retrieve the Name of Second Slave Table Name for the Report)
GETPROPERTY REPORT 'REPORT_TABLE_NAME[2]' vReportSlaveTable2
RETURN
Variable vReportSlaveTable2 will return the name of second slave table
associated with a report in a Sub-Report environment.
For completely automated routines, sample reports and more, refer to:
. Running R:BASE Your Way! (Part 10) for R:BASE 7.5 (Conference Edition)
. Running R:BASE Your Way! (Part 12) for R:BASE V-8 (Conference Edition)
http://www.rbase.com/conference
Stay tuned for more ...
Very Best R:egards,
Razzak.
