REP0005 - Generate Report - Column Limit Exceeded

Expand / Collapse
 

REP0005 - Generate Report - Column Limit Exceeded


Article ID: 51334 - Last Review: November 30, 2011

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's 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

Keywords: REP0005



Rate this Article:
     
Tags:

Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:Thursday, December 01, 2011
Last Modified By: kmiddlemiss
Type: ERRMSG
Article not rated yet.
Article has been viewed 3,419 times.
Options