REP0005 - Generate Report - Column Limit Exceeded

DESCRIPTION

The number of columns in the report will not fit in an Excel 95-2003 file.

SEVERITY

Error

IMPACT

The report will be inaccurate as it will not contain all the data required.

TROUBLESHOOTING STEPS

Excel 95-2003 has a limit of 256 columns on a worksheet. The report that is being generated contains more than 256 columns.

You will see this error under two conditions:

1. The ExcelVersion in the config file for the Reporting Service is set to Excel 95-2003 (Value = 1).
2. The user has selected Export to Excel 97-2003 from the Preview tab of Flexible Reporting.

The best way to avoid this error is to reduce the number of columns in the report. If this is not possible these are the users' other options.

1. Set the ExcelVersion in the config file for the Reporting Service to 0 for autodiscover.
2. The user must select Export to Excel 2007 from the Preview tab of Flexible Reporting.

To change this setting from the CCM server go to %InstallDir%/Programfiles/PrairieFyre/CCM/Services/Reporting and locate the Reporting.exe.config file. Right Click and Open with Notepad. Do a CTRL+F for ExcelVersion and set it to the desired setting.

You will need to restart the "prairieFyre Reporting Service" via the services control manager after making this change.

APPLIES TO

CCM

References

• MiContact Center Administration and Installation Guide
• MiContact Center User Guide
• MiContact Center and Business Reporter System Engineering Guide
• Multimedia Contact Center Installation and Deployment Guide
• Business Reporter User Guide