Troubleshooting
Problem
User clicks 'Reports - Report Books'. User chooses a 'Report book', and then clocks 'Output'. User changes the 'Output Selection' to a "file". User is prompted to give it a file name. However, user can only choose the following output formats: * Microsoft Excel Workbook (.xls) * Web Page (*.htm, *.html) * CSV (Comma Delimited) (*.csv) User cannot choose Excel 2007/2010's format *.XLSX.
Symptom
When defining 'Report Books', it is only possible to choose 'XLS' (not XLSX) as the output format:
Similarly, if a user clicks "Reports - Run" and chooses a report book, and then clicks 'File' as the output, then they can only choose 'XLS' (not XLSX') as an output:
If a user manually runs a report (or runs the Report Book) they receive the report in XLS (Excel 2003 and earlier) format, not XLSX (Excel 2007 and later) format.
Afterwards, the user opens this file in "Excel 2007" (or later). The file opens in Excel 'Compatibility Mode':
Depending on how the client PC is configured, the end user may receive a Microsoft Excel warning message (when opening an XLS file in "Compatibility Mode").
- For mode details, see separate IBM Technote #1458165.
Log InLog in to view more of this document
Was this topic helpful?
Document Information
More support for:
IBM Cognos Controller
Software version:
10.2.0, 10.1.1, 10.1, 8.5.1, 8.5, 8.4, 8.3
Operating system(s):
Windows
Document number:
415025
Modified date:
08 May 2025
UID
swg21459589