News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Item Attribute in Repo...

Business Central forum

Suggested answer

Item Attribute in Report Dataset

(0) Share

Report

Report

Posted on by N. Steinbusch

5

Hi Community,

I would like to create a report Dataset with item attributes. That would allow me to create a Report Layout that displays my item and all his attributes (and the value of theses attributes) in a fancy Word document.

Do you have any idea which tables and fields I would need to use in Visual Studio in order to create that Dataset? Or even better, if a report already exists with that kind of information?

Thank you ! :-)

All the best,

Nicolas.

Categories:

Reports and Business Intelligence

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Steven Renders 5,043 Moderator on at

Like (0)

Report
RE: Item Attribute in Report Dataset

There are some objects that can help.

Have a look in:

Codeunit:

7500 Item Attribute Management

Tables:

7500 Item Attribute No

7501 Item Attribute Value

7502 Item Attribute Translation

7504 Item Attribute Value Selection

7505 Item Attribute Value Mapping

7506 Filter Item Attributes Buffer

Also the Image Analyzer Extension can serve as an example:

[View:https://github.com/microsoft/ALAppExtensions/tree/master/AddOns/ImageAnalysis:750:50]
Suggested answer

TeddyH 12,861 Moderator on at

Like (0)

Report

RE: Item Attribute in Report Dataset

Use Item Attribute Value Mapping and Item Attribute Value table.

Helpful resources

News and Announcements

New Dynamics 365 Community Call! (ERP Edition)

Quick Links

Leaderboard

#1

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

#2

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

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans