Once a query is processed and data results are returned to the desktop, you can use the Interactive Reporting powerful reporting and analysis tools to create custom views, cross-sections, and drill-downs to slice and dice data and view multidimensional relationships.
You can create multiple views of the data or display the information in any form and from any angle possible. At any time, you can reconnect to the server and update your reports and charts with fresh data from the database.
You can also use Interactive Reporting to work autonomously with data after disconnecting from the server. Even without a database connection, you can continue to analyze data and produce reports. You can save results in the desired format for additional refinement in Interactive Reporting, or export the data to other applications for further analysis.
Interactive Reporting enables you to create a wide variety of reports:
Tables—Columnar arrangements of data. Tables are used as building blocks in other reporting sections. You can apply filters to tables, add computed items, include subtotals and grand totals, as well as summary totals such as sum, count or average.
Pivot tables—Interactive tables that quickly summarize or cross-tabulate large amounts of data. You can rotate rows and columns to see different summaries of data or display the details for areas of interest. A pivot table summarized data by using a summary function, such as Sum, Count, or Average. You can include subtotals and grand totals automatically, or use your own formulas by adding computed items.
Charts—Visual display of information; fully interactive, three-dimensional views of data. Interactive Reporting displays data from results sets as bars, lines, columns, pie slices, or other shapes in the chart. When you create a chart, the values from the worksheet are automatically represented in the chart. Charts are linked to the data they are created from and are updated when data is changed.
Custom reports—Creates free-form presentation-quality reports with graphic objects, predefined fields, band-style report data from multiple data sources and computed fields, charts, and pivots; Smart reports enable you to embed charts and pivot tables and show only the data that is relevant to the section in which they are placed.