Changing the default file extension for Excel 2002 spreadsheets

By default, Excel 2002 spreadsheets sent by e-mail are created in Excel Multipart HTML format with the .mht file extension. You can change the default file extension to .xls by setting the RSVP.FILE.EXTENSION.XLS parameter to true.

Setting RSVP.FILE.EXTENSION.XLS to true does not change the file content, which remains as Excel Multipart HTML.

Procedure

  1. In IBM Cognos Administration, on the Configuration tab, click Dispatchers and Services.
  2. In the Configuration pane, under Name, click the dispatcher to see the services.
  3. Beside BatchReportService, click Set properties.
  4. Click the Settings tab.
  5. For the environment category, next to Advanced settings, click the Edit link.
  6. Select the Override the settings acquired from the parent entry check box.
  7. In the Parameter column, type RSVP.FILE.EXTENSION.XLS.
  8. In the Value column, type true.
  9. Click OK twice.
  10. Repeat the same steps for the ReportService, and restart the server.
Parent topic: Customizing the Functionality of IBM Cognos Software