We have a custom purchase order form that has quit working since upgrading from 10.1.600 to 10.2.700. The customization consists of an updated RDD with an added relationship between PORel and JobMtl (linked on company, jobnum, assyseq, and jobseq) and the RDL includes some UD fields from JobMtl.
The error I’m getting is:
System.ArgumentException: Column ‘Calc_AttrShortDescription’ does not belong to table PORel.
I can’t find this field referenced anywhere in the RDD or RDL (or its DataSource SQL).
We have an earlier custom POForm that does not have the added relationship to JobMtl and it runs fine.
Assuming that you can’t find the field in the rdd exclusions, calculated fields, or references to that field in the main SSRS report dataset or any associated subreports…i would just build the rdd from scratch.
With experience upgrading all sorts of versions of SSRS reports from 10.x to 10.x.xx and higher, RDD’s will always be finicky and easily corruptible to me. I always tried to diagnose the error for a bit, but would find myself spending less time recreating the RDD than trying to fix the error I probably wouldn’t be able to find. Because of the proprietary nature/clunky screens of RDDs it was just too time consuming.
Same thing happened to me. You can actually go into the RDD, and add a new Calculated field to the table. You don’t program any sort of calculation, you just add the field with the name “Calc_AttrShortDescription” and it should work.
I was hitting Calc_SubAsmSeq as the field on JobMtl table for Job Pick List, tried adding it to this “Crystal” RDD, did not seem to work. I already did work converting the report to SSRS so I just pointed the “Crystal” versions of the Report Style to the SSRS RDD that I knew was working, and that worked.