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 12 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 73,698 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 11,425 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 32,748 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 32,748 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

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans