Active Technologies Report Overview

An active report is a report that is designed for offline analysis. When using an active report, you can:

• Interact with the data, using analysis options similar to those found in an Excel® workbook, without any connection to a server. Analysis options include filtering, sorting, charting, and much more.
• Work offline without any additional plug-ins or programs. An active report is a self-contained report, meaning that it contains all the data and JavaScript® within the HTML output file. Packaging the data and the interactive functions in the HTML file also makes the output highly compressible for email and transparent to security systems.
• Save the report on a local machine with active report functionality. Since no connection to a server is required to view the data or use the analysis options, you can save and use the report anywhere.

  Note: Performance may vary across browsers due to browser-specific memory limitations. For very large reports, Internet Explorer® may produce an error. For more information, refer to the Microsoft® website.

An active report for Adobe Flash Player includes most of the capabilities available in the HTML version of active reports in a visually enhanced, user-friendly report format. An active report delivered as a self-contained Adobe Flash SWF file that is Adobe Flash Player compatible allows for faster analysis of large data sets and interaction with the active report.

When working with an active report, you can:

• Filter or highlight data.
• Sort data within any column in ascending or descending order.
• Apply calculations to columns and choose the location at which to display results.
• Control the display of data by hiding columns, freezing columns, limiting the number of rows per page, and using graphic visualization to compare column values.
• Create a variety of simple or advanced charts (pie, line, bar, or scatter) and Rollup Tables.
• Apply a global filter to multiple reports within the same HTML page.
• Export report data and chart data.
• Restore original report settings.
• Run active reports on your mobile device with the Opera™ browser (Version 8.60 U2 or higher) installed. See the Opera website for a list of supported devices.
• Run active reports on your iPhone® mobile device. For the best performance results, it is recommended that you set a maximum of 500 records for a mobile report.

  Some active report functionality is drag and drop based, and thus not supported with iPhone.

The following image shows an HTML active report. The pop-up menu is open for the Sale Unit(s) column, with the Calculate Avg operator selected.

The following image shows the options that are available at the cell level for a report in active report format. Included are the options that reflect Auto Drill, Multi Drill, and Auto Linking functionality. The applicable documentation for your graphical tool contains more information on that functionality.

Note:

• Depending on how your active report has been set up, some options may not be available in your report.
• When using active reports, it is recommended that you set the system font display to normal to ensure that the menu icons display correctly.
• Freeze options are only available when a report does not fit in the current window. Therefore if your report fits in the current window, Freeze options appear grayed out in the menu. If you resize the report, or a column or row extends beyond the proportion of the window, then Freeze options become activated and are available for use.