In an upgrade from 10.1.400.14 to 10.2.100.8 the custom SSRS report “AR Form” now fails to run with the below error…
“Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: Column ‘Calc_DspDocLineTax’ does not belong to table InvcDtl.”
Where is this field being referenced?
- I took all the RDL files (main report and all the sub-reports/sub-sub-reports) and searched all the XML and could not find this field referenced in any of the SSRS RDL files.
- I also exported the Report Data Definition and then opened it up in a text editor and searched for the field too, and could not find it in the RDD either.
- Where else could this field be referenced?
This is a highly customized SSRS report with sub-reports and sub-reports inside the sub-reports (about 9 in total), so re-building this report is not ideal. I’d really like to track-down this rogue field reference and correct it.
(NOTE: This started out being one of the “…exceeds the maximum of 1024 columns” errors. Had worked on
excluding columns, and then when I stopped to see if I had gotten below the limit, I received this error. But this calculated field is not showing in the Report Data Definition.)
Any suggestions or ideas on where to find this ghost field?