Skip to main content

Notifications

Microsoft Dynamics AX forum
Answered

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

Posted on by 3,053

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'.

Categories:
  • Jordan Campos Profile Picture
    Jordan Campos 5 on at
    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 Profile Picture
    Zain Bokhari 3,208 on at
    RE: SSRS error 'Unable to add the table field..'

    Great :)

  • Suggested answer
    b_radlyjames Profile Picture
    b_radlyjames 3,053 on at
    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 Profile Picture
    Zain Bokhari 3,208 on at
    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.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,186 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,996 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans