psTableSchema - cDRReport ¶

Type¶

String

Default¶

None

Arguments¶

Argument	Description
`sReportID`	ID of the report. Can be ID of the main report or the ID of a sub-report. This argument can be passed as an empty string, which can be represented as `C_USEMAINDRREPORTID`.
`iTable`	The index of the table in the report.

Description¶

Sets/Gets the schema name of the table identified by the iTable parameter. When the data source is the embedded database and the tables are selected via the filelist, this property returns an empty string value for each table. When the tables are selected as individual tables, the property returns the name (including the path) to each of the tables.

If you pass a table number that is higher than the number of tables in the report or if it is negative, an error will be generated.

This property cannot be used before the report OCX object is initialized. The COM object creation is performed as part of the OpenReport method if it has not been done beforehand.

[psTableCatalog](../both/pstable-catalog.md
psTableName
[psDatabaseConnection](../both/psdatabase-connection.md
psDatabaseName

DataFlex Framework usage¶

Web
Windows
FlexTron

Sample¶

Object oReport is a cDRReport
    Set psReportName to 'MyReport.dr'
End_Object

Object oRunReportButton is a Button
    Set Label to 'Run Report'

    Procedure OnClick
        String sReportId

        Get OpenReport of oReport to sReportId

        // Set the schema of the second table to 'MySchema'
        Set psTableSchema of oReport sReportId 1 to 'MySchema'
        Send OutputReport of oReport
    End_Procedure
End_Object

psTableSchema - cDRReport¶