Retrieving Reports

The Simba Salesforce ODBC Connector supports Salesforce reports by treating them as stored procedures. When you call the SQLProcedures ODBC function without setting any parameters, the connector returns a list of reports from Salesforce.com.

You can retrieve a report by calling the report name using the same syntax as you would for stored procedures. For example, to retrieve a Salesforce report named "Activity Report", you would execute the following statement:

{call "Activity Report"}

You can then work with the data in the report as you would with any other Salesforce.com data.

Important:

Important:

Reports that are designed to display in HTML might not display properly when retrieved through the connector.

Related topics