I cannot export my report data in either an .xls format or .csv format.

If you are running your reports from within Internet Explorer and cannot export your report data in either Excel (.xls) or Comma Separated Values (.csv) formats, it is because of Internet Explorer. There are three 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. We use both Mozilla Firefox and Microsoft Internet Explorer extensively, and onle experience these issues while using Internet Explorer. 

What are the three issues

The functionality you need to export report results is disabled by default in your Internet Explorer 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, and in most cases you will need to acknowledge ReportNet as a Trusted Site.

  • 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.

How to 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.
  4. When the pop-up blocker settings dialog box opens, enter e-reports.wayne.edu into the address of website to allow field. 
  5. Click the add button.
  6. The reports site has been added to the allowed sites list.
  7. At the bottom of this dialog box is filter level.  Click the down arrow and select Low: Allow pop-ups from secure sites.
  8. Click the close button.

How to 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 Security Zones 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.

How to make ReportNet a trusted site

  Finally, you need to 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.

Click on the sites button just below and to the right.

  • The web sites box opens. The box could be empty. However, if there are entries here, look to see if e-reports.wayne.edu is present. If the field is blank or does not contain e-reports.wayne.edu continue to step six. If the the field contains the address 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.
  1. In the field Add this web site to the zone type e-reports.wayne.edu.
  2. Click the add button.
  3. The URL e-reports.wayne.edu should now appear in the web sites box.

  4. Click OK to close the trusted sites dialog box.
  5. When the box closes, click apply. Click close to exit the Internet Options dialog box.

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

  • These procedures were created using Internet Explorer 6.02.  As you already know, we get no advance notification from Microsoft regarding changes that may occur within your Internet Explorer browser as a result of their updates or upgrades.

If  you have followed the procedures described in this article, and you still cannot export your reports, or you have been exporting but now you cannot, please email us by clicking on the EMAIL link located in the box at the upper right-hand corner of this (or any) page of this article.