CHISR Code Line

Epicor ERP 10
, ,
1

My AR Form SSRS report will occasionally error because

… The Hidden expression for the tablix ‘Table1’ contains an error. The expression references the field ‘CHISRCodeLine’, which does not exist in the fields collection. Expressions can only refer to fields within the current dataset scope…

So here is where I am stumped. I’ve recently made a change to this SSRS report completely un-related to the CHISRCodeLine. The CHISRCodeLine is in the original SSRS Report and I didn’t change the report data definition at all. This error only seems to happen on the changed report not the old one. I verified that CHISRCodeLine field is in the old report.

The error suggests the field is missing in the dataset which to me says the report data definition but I didn’t make a change to the RDD. I also have no idea what CHISRCodeLine is/means/is used for. Unfortunately Field security maintenance is not exceptionally helpful in this either where the description is ‘CHISRCodeLine’.

Any suggestions or leads others would suggest I look into?

Thanks,
Max

2

Have you done a Find on the report query to see if that field is there? If it is, then you should be able to get back to the table it is coming from in the RDD.

3

I’m not sure exactly what you are suggesting but I did do a find in the report in Notepad++ and found where it was used, etc.

I also know it’s coming from the InvcHead table, and it’s in the RDD and not excluded.

4

I was suggesting you search the Dataset query for the field to see if it is in there. If it is coming from the InvcHead table, it should probably be a T1 field.

5

I think CHISRCodeLine is a field from the database. It belongs to InvcHead table and it is not a calculated field. Check to see if you don’t have it excluded (both field and label)