IBM Support

Convert .html and .mht extensions to .xls extension for sending email in Cognos BI

Question & Answer


Question

Sending a report by email in Excel format, the file extension is .html or .mht by default. This document describes how to directly send Excel output files with a .xls extension by adding extra advanced properties in Cognos Connection

Answer

In Server Administration, add "RSVP.FILE.EXTENSION.XLS" parameter to ReportService and BatchReportService.

  1. Open Cognos Connection.
  2. Click Launch menu in the portal and select Cognos Administration
  3. Click Configuration Tab
  4. Select Dispatchers and Services from the menu on the left side
  5. Click the dispatcher to configure
  6. Select Set Properties for ReportService
  7. Select the Settings tab
  8. Find the property that is named Advanced Settings, and Click the Edit... link
  9. Check Override the settings acquired from the parent entry
  10. In the first empty set of boxes, type in the parameter name RSVP.FILE.EXTENSION.XLS and set the value to TRUE
  11. Press OK.
  12. Click Launch menu in the portal and select Cognos Administration
  13. Click Configuration Tab
  14. Select Dispatchers and Services from the menu on the left side
  15. Click the dispatcher to configure
  16. Select Set Properties for BatchReportService
  17. Select the Settings tab
  18. Find the property that is named Advanced Settings, and Click the Edit... link
  19. Check Override the settings acquired from the parent entry
  20. In the first empty set of boxes, type in the parameter name RSVP.FILE.EXTENSION.XLS and set the value to TRUE
  21. Click OK.
  22. Restart the service.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cognos Administration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2;10.1.1;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21342065