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.
