Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Modify DataItemTableVi...
Small and medium business | Business Central, N...
Suggested answer

Modify DataItemTableView in Standard Report

(0) ShareShare
ReportReport
Posted on by ShanAbeywicrema 940

I want to add another const value in report 214. Is it possible to modify data item filters in AL Code

  • Suggested answer
    Bjoern Waninger Profile Picture
    Bjoern Waninger 2 on at
    Modify DataItemTableView in Standard Report
    Just wondering: Now we have version 23.5. and it seems to be still not possible to change the DataItemTableView with a reportextension?
    It is a huge pain duplicating a standard report only for the purpose of changing the sorting of dataitems :-(
  • Suggested answer
    KB-22080944-0 Profile Picture
    KB-22080944-0 3 on at
    Modify DataItemTableView in Standard Report
    Thx MazlumMomo
     
    I,ve managed to do it even without the clear/reset by using filtergroup(2). Now i don't loose all other filters that might be set in the request page.
     
        dataset
        {
            modify("Sales Header")
            {
                trigger OnAfterPreDataItem()
                begin
                    "Sales Header".FilterGroup(2);
                    "Sales Header".setfilter("Document Type", '%1|%2', "Document Type"::Order, "Document Type"::Quote);
                    "Sales Header".filtergroup(0);
                end;
            }
        }
  • MazlumMomo Profile Picture
    MazlumMomo 12 on at
    RE: Modify DataItemTableView in Standard Report

    Hello shan abeywicrema 

    I had similiar issue. Just removed all filters and added manually specific filters I need for the data item:

    pastedimage1680537131536v1.png

    Make sure that you assign all the necessary filters and not only the one you wanted to change.

    Hope this helps.

    CU,

    Mazlum Momo

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 75,595 Super User 2024 Season 2 on at
    RE: Modify DataItemTableView in Standard Report

    Hi, Unfortunately, the property 'DataItemTableView' cannot be customized now.

    pastedimage1649380349355v1.png

    So if you want to do it now, just copy it to create a new report.

    Hope this will help.

    Thanks.

    ZHU

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 169 User Group Leader on at
    RE: Modify DataItemTableView in Standard Report

    There are new options and capabilities coming in 2022 Wave 1 that I saw demonstrated this week for easily adding fields. (version 20)

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 993 Super User 2024 Season 1 on at
    RE: Modify DataItemTableView in Standard Report

    You can not do that as en extension to the current report. But if you create a copy of the 214 report it will be possible to implement a work around giving you the result you want.

  • ShanAbeywicrema Profile Picture
    ShanAbeywicrema 940 on at
    RE: Modify DataItemTableView in Standard Report

    Hi  Inge M. Bruvik,

    This report already has a dataitemproperty filter. Type=Item, I need to add Type= Item | G/L Account.

    This is the challenging part.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 993 Super User 2024 Season 1 on at
    RE: Modify DataItemTableView in Standard Report

    To add a constant value i guess you do not need to modify a filter?

    You can create a report extension and then add the constant value as a column in the report.

    Or did i misunderstand you?

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Modify DataItemTableView in Standard Report

    Hello,

    We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

    www.yammer.com/dynamicsnavdev

    dynamicsuser.net/.../developers

    I will open this up to the community in case they have something to add.

    Thanks.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans