web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Type Record not supported

Microsoft Dynamics AX (Archived)

Type Record not supported

(0) Share

Report

Report

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)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Konrad U 804 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Martin Dráb 239,647 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 21

#2

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans