web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Type Record not supported
Microsoft Dynamics AX (Archived)

Type Record not supported

(0) ShareShare
ReportReport
Posted on by Community Member

Hello everybody from an AX newbie :-)

I’m creating an SSRS report where 4 tables are involved. Pretty easy and it runs fine in the AOT (tested on a view).

Nevertheless Visual Studio is not able to accept the query in the report dataset due to:

“Data or calculated fields with type Record are not supported.”

I understand it can be an issue related to a display method returning an illegal type.

I’ve found the  table that is causing the error (Salestable) but I’m not able to go further than this…

- How can I list all display methods of the table?

- How do I find out which datatype are they returing?

- How do I “convert’ it to a legal one, once found?

As I’m still building my Knowledge in AX2012, so any small suggestion/hint that can bring me a step forward will be really appreciated!

Thanks in advance,

Best,

Andrea

*This post is locked for comments

I have the same question (0)
  • Konrad U Profile Picture
    Konrad U 804 on at

    Hi Andrea,

    So far you are on the right track. In answer to your inquiry on how to look at display fields, go to the Salestable in the AOT and open look at the methods. Display ones are obvious, fields on your report that are not in the table.

    The why is a little more complicated. Display fields are used to access data from other tables, a code form of what is a database join. To keep AX happy you can add the extra table in the report and join it via normal SSRS function or look at the solution here that might work. This is referencing and Excel add in but appears to be the same issue.

    community.dynamics.com/.../96346

    Good luck!

    Konrad U

  • Martin Dráb Profile Picture
    Martin Dráb 237,817 Most Valuable Professional on at

    To find all display methods in SalesTable, simply search for the display keyword. Another strategy would be checking custom method first, because it's not caused by a standard method.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Scott_itD Profile Picture

Scott_itD 2 Community Manager

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans