SSRS error 'Unable to add the table field..'

(0) Share

Report

Posted on by b_radlyjames

3,081

I have created a report that uses a query for it's dataset. Nothing unusual.

I can also preview the report in VS 2010. Data looks perfect along with the design.

When running this in AX, I get:

Unable to add the table field 'MyCustomField' to the query source 'ProjInvoiceTable'. Table field 'MyCustField' does not exist on table 'ProjInvoiceTable'.

'MyCustomField' is on 'ProjInvoiceTable'.

*This post is locked for comments

All responses (4)

Answers (1)

Jordan Campos 5 on at

Like (0)

Report

RE: SSRS error 'Unable to add the table field..'

Great! I did the same and works, just in D35, we need to restart the IIS and the reporting server
Zain Bokhari 3,208 on at

Like (0)

Report

RE: SSRS error 'Unable to add the table field..'

Great :)
Suggested answer

b_radlyjames 3,081 on at

Like (3)

Report

RE: SSRS error 'Unable to add the table field..'

Thank you Zain. Along with an AOS restart and SQL Reporting Services restart, it now works.
Verified answer

Zain Bokhari 3,208 on at

Like (4)

Report

RE: SSRS error 'Unable to add the table field..'

Looks like an issue with caches and db sync. Try that first if not, remove your customization, do a db sync and then add the table customization + query again and redeploy the report clear caches and try again.