Locating the query behind a report

Some Reports navigation items contain a Queries folder. The Queries folder contains the queries behind the reports. Typically, the query will have the same name as the report.

To locate the query behind a report, do the following:

  1. Go to Reports in the site navigation and select one of the reporting navigation items, such as Contact reports.
  2. Open the Queries folder. If there is no Queries folder, then there is no query behind the report and the report is generated using SQL Server Reporting Services (SSRS) only.

  3. Select the query named after the report.

    4. Example: The Change Log report is generated by the Change Log Report Query.

  4. Run the query.