In this section: How to: |
You can save an active report from your browser to another location. You can send active reports as an HTML attachment. You can also export data in an active report to HTML, CSV (comma delimited), or XML (Excel) formats. You can export the entire data set or only filtered records. Export does not include the JavaScript that makes interaction possible due to browser security settings, only static data is exported. All data that you see in your report is exported. For example, if you have applied calculations to a column, those calculations appear in the exported data. In addition to exporting data, you may also export charts created in active reports to Microsoft® Excel®, Word®, and PowerPoint®.
The active cache feature does not support the Save Changes and Send as E-mail options for active reports.
In order to save an active report, ensure that your Temporary Internet Files setting is set to Automatic.
Note:
The Prompt dialog box opens.
To use the Save Changes option, you must enable ActiveX® in your browser security settings.
The report is saved with the most recent modifications applied.
The original report name does not show these modifications.
You can print All records or Filtered only.
Tip: Click the arrow in any column heading and select Filter to filter data. For more information about filtering, see Filtering and Highlighting Data.
The data is sent to the printer.
The Mozilla Firefox® browser and the Safari browser do not support the Export XML (Excel) feature of HTML active reports.
Using Safari as the web browser has identical functionality to Mozilla Firefox. A limitation for both Safari and Mozilla Firefox is the unavailability of the export directly to Microsoft Excel function in the HTML active report. The export directly to Microsoft Excel function in HTML active reports requires ActiveX controls, which are supported only when you use Internet Explorer as the web browser.
The active report menu options Export to HTML and Export to CSV (comma delim) export data in Unicode (UTF-16) only. Exporting data in an encoding scheme other than Unicode is not supported. For instance, in the Save HTML Document dialog box in Internet Explorer, you must select Unicode from the Language drop-down list. The requirement that you export data in Unicode applies to all platforms.
Formatting is only preserved for reports that are exported in HTML format. If you export data to HTML and then change the file extension in the Save as dialog box to .xls, when you open the file in Excel, it does retain all formatting.
The Save as dialog box opens.
A new browser window also opens that shows the exported data. This data shows due to browser security features.
Field formats with dollar signs and decimals are not exported to CSV and XML (Excel) formats. They export as plain integers.
When you export charts, the selected application opens and a chart is created in a new worksheet, document, or presentation. You must use Internet Explorer as the default browser in order to successfully export data to a Microsoft Office application.
Ensure that ActiveX controls and plug-ins are enabled.
The chart is exported to the selected application.
The chart opens in the corresponding Microsoft Office application.
The following image is an example of a chart exported to Excel.
The following image is an example of a chart exported to Word.
The following image is an example of a chart exported to PowerPoint.
You must use Internet Explorer as the default browser in order to successfully send active reports.
The Mozilla Firefox browser and the Safari browser do not support the Send as E-mail feature of HTML active reports.
Using Safari as the web browser has identical functionality to Mozilla Firefox. A limitation for both Safari and Mozilla Firefox is the unavailability of Send as E-mail functions in the HTML active report. Send as E-mail functions in HTML active reports require ActiveX controls, which are supported only when you use Internet Explorer as the web browser.
The HTML file that is created by Active Technologies contains JavaScript so that you can interact with the data in a disconnected mode. When you send an active report or active dashboard in HTML using email, many email client programs on a smartphone or any other mobile device can block the JavaScript in the attachment. A third-party tool, such as the Mobile Faves App for the iPhone or iPad, may be required in order to correctly view the attachment.
The Prompt dialog box opens.
If Microsoft Outlook® is your default email system, a message is opened with the AHTML report as an attachment.
If Microsoft Outlook is not your default email system, save the active report as an HTML document and attach the file to your message.
Note: When using Internet Explorer 7 and Microsoft Office Outlook 2003 or 2007 on the Windows operating system, you may receive the error message Access is denied if you click the attached HTML file to preview the active report or active dashboard before you send it. Once the email message is sent, the HTML file opens and the active report or active dashboard appears correctly on the machine of the email recipient.
How to: |
You can generate images for active reports in connect or disconnect mode by placing images in the apps directory. If images are in the WebFOCUS Reporting Server application directory and no URL is specified, the JPEG image converts to a JavaScript image at run time.
All resizing of images should be done outside of Developer Studio and image size should not be larger than 200x200 pixels. Embedding images does not support sizing or positioning of the image and it uses the current size and default position for that object. Larger images increase the time required for conversion and the loading of the report in the browser.
There are multiple ways to generate images for active reports. You can do one of the following, but not both.
To place an image in the WebFOCUS Reporting Server application directory:
In disconnected mode, images for AHTML reports must be JPEG images.
The image is added to the image list.
The image is added to your apps directory and inserted into your report at the selected location.
To specify a full or relatively qualified URL:
If no URL is specified, the JPEG image converts to a JavaScript image at run time.
WebFOCUS |