Exporting Report Data into Excel

From EAUserTools

Contents 1 I cannot export my report data in either an .xls format or .csv format. How do I fix this problem? 1.1 Enable Pop-ups For The ReportNet Site. 1.2 Enable Automatic Prompting For File Downloads. 1.3 Make ReportNet A Trusted Site.

I cannot export my report data in either an .xls format or .csv format. How do I fix this problem?

If you are running your reports from within Internet Explorer (IE) and cannot export your report data in either Excel (.xls) or Comma Separated Values (.csv) formats, the problem is with Internet Explorer. Actually, there are three (3) potential issues. Any combination or all three may be the culprit. How many of these changes you will have to make depends on how your browser options are configured before you begin this process. We single out Internet Explorer as the source of your difficulty because Cognos ReportNet will operate in alternative browsers, e.g., Mozilla's Firefox, where these issues do not exist.

What are the three issues? The functionality you need to export report results is disabled by default in your Internet Explorer (IE) options. To be able to export your reports to Excel, you must "Turn Off Pop-up Blocker (for ReportNet)," change the default setting for "Automatic Prompting for the file downloads" to ENABLE, then, in most cases, you will need to acknowledge ReportNet as a "Trusted Site."

Note: Whether exporting your reports in either .xls or .csv formats, the difficulties probably persist. Why? Because ReportNet's default application for opening either file type is Excel. If you want to export .csv files, you'll have to change these options, also.

These changes do not need to be done in any particular order. If you find that one of the default options has been changed, just verify the accuracy of the change and move on to the next procedure.

Tutorial

Enable Pop-ups For The ReportNet Site.

The download dialog box you need to open cannot because Internet Explorer sees it as a pop-up. By following this process, you will enable pop-ups from ReportNet (and any other secure sites). All other pop-ups will remained blocked.

1. Click TOOLS on your Internet Explorer menu bar.
2. Select POP-UP BLOCKER.
3. Click POP-UP BLOCKER SETTINGS...
   
   When the POP-UP BLOCKER SETTING... dialog box opens, enter e-reports.wyane.edu into the ADDRESS OF WEB SITE TO ALLOW: field.
   
   
4. Click the ADD button.
5. The reports site has been added to the ALLOWED SITES: list.
   
   
6. At the bottom of this dialog box is FILTER LEVEL. Click the down arrow and select LOW: ALLOW POP-UPS FROM SECURE SITES.
   
   
7. Click the CLOSE button.

Enable Automatic Prompting For File Downloads.

Now that pop-ups are enabled from ReportNet, you have to instruct Internet Explorer to display the downloads dialog box by enabling Automatic Prompting for the file downloads.

1. Open Internet Explorer, click TOOLS on the menu bar.
2. Select INTERNET OPTIONS from the list.
   
   
3. Click the SECURITY tab.
4. In the Select a Web content zone... section, click on the INTERNET icon.
5. Under SECURITY LEVEL, click the CUSTOM LEVEL button.
   
   
6. Scroll down the list until you see DOWNLOADS.
7. Under Downloads, find Automatic Prompting for the file downloads. Click ENABLE.
   
   
8. Click OK to close the Custom Level dialog box.
9. When the box closes, click APPLY. Click CLOSE to exit the Internet Options dialog box.

Make ReportNet A Trusted Site.

Finally, you must tell Internet Explorer that the ReportNet site can be trusted to be a secure site.

1. Open Internet Explorer, click TOOLS on the menu bar.
2. Select INTERNET OPTIONS from the list.
   
   
   
3. Click the SECURITY tab.
4. This time, click on the TRUSTED SITES icon.
5. Click on the SITES button just below and to the right.
   
   
   NOTE: The WEB SITES box opens. The box could be empty. However, if there are entries here, look to see if www.e-reports.wayne.edu is present. If the field is blank or does not contain www.e-reports.wayne.edu, continue to step 6. If the the field contains the address www.e-reports.wayne.edu and you have completed the previous two procedures and still cannot export, see the note at the bottom of this page.
   
   
6. In the field Add this web site to the zone type e-reports.wayne.edu.
7. Click the ADD button.
8. This URL, www.e-reports.wayne.edu , should now appear in the WEB SITES box.
   
   
   
9. Click OK to close the TRUSTED SITES dialog box.
10. When the box closes, click APPLY. Click CLOSE to exit the Internet Options dialog box.
    
    

Congratulations! You are now configured to export your ReportNet reports into Excel.

Return to the E-report Wiki Home Page


The category links below will redirect you to topics (categories) that are related to the contents of this page.