14 Building Custom Reports in Microsoft Excel

iQuery is an add-in that enables you to build custom queries in Microsoft Excel. When you build a query, you select data that appears in a Microsoft Excel spreadsheet after you run the query.

You can save the queries in Microsoft Excel or you can save them as reports. When you save a query as a report, users assigned to the custom reports role can run the reports from the Reporting and Analytics web application.