The contents of the report will not fit in an Excel 95-2003 file.
Warning
Reports will seem inaccurate when compared to Summary reports as it doesn't contain all the data.
The ExcelVersion config setting for the Reporting service is set to Excel 95-2003. The data returned for this report is greater than 65000 rows and will not fit in an Excel 95-2003 file.
Either change the Report service ExcelVersion value OR shorten your reporting time range in order to reduce the number of rows on the report.
Here are valid setting for ExcelVersion:
ExcelVersion=0 selects the version of Excel based on the number of rows required: <= 65000 rows uses Excel 95-2003; > 65000 rows uses Excel 2007.
ExcelVersion=1 always uses Excel 95-2003.
ExcelVersion=2 always uses Excel 2007.
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.
CCM