Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Adding new field to a query Report

Posted on by 95

Dear Gents;

I am Trying to add one new field i.e. Fixed Asset location to the fixed assets balance report but the problem is this is a query based report and data is coming from a view named AssetBalances. I try to add a display method on this view but method is not returning anything...

Can somebody guide me how can i use display method on views or how can i display location in this report..

Thanks and regards...

*This post is locked for comments

  • Suggested answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,647 Moderator on at
    RE: Adding new field to a query Report

    Adding field makes sense as Brandan mentioned . If field  you needed is present in view datasources , you can add it directly . If not , please share more details about your method  which is not returning any value.

  • Blue Wang Profile Picture
    Blue Wang on at
    RE: Adding new field to a query Report

    Hi Mohamed,

    You can set DataSet to point to query. Then use display method as a field.


    Follow this step:
    In Visual Studio, set dataset to point to the query. The display methods will be shown in the dataset after the list of fields.
    In the design of reports, the display method is like a field.
    Look at the report CustGrossMarginByAccount_NA.

    I hope it will help you.

  • Suggested answer
    BrandonSA Profile Picture
    BrandonSA 1,669 on at
    RE: Adding new field to a query Report

    Hi

    Why do you need a display method? Why don't you just add the field to the view normally, and then add it to the query?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans