Description

Returns a table array of source results defined in a given report and SQL source.

Remarks

This function is useful for when you need to get data out of Fusion Sophis / FusionInvest that is not exposed as a field in FusionLink.

Steps

1. Define a report in the Reporting Module in Sophis
2. Add a SQL source and add the query to sql editor
3. Execute the sql using this function passing the Report and Source name

Syntax

GETRREPORTSQLSSOURCERESULTS(report_name, report_name)

The GETRREPORTSQLSSOURCERESULTSfunction has the following arguments

• report_name Required. The name of the report.
• report_name Required. The name of the source in the report.

Remarks

• If the report cannot be found, the function will return a "Report cannot be found" error message in the cell.

Example

Formula	Result
=GETRREPORTSQLSSOURCERESULTS("SqlQueries", "FuturesExpiringWithin7Days")	A table with the results of the SQL query