Small and medium business | Business Central, N...

Modify DataItemTableView in Standard Report

(0) Share

Report

Posted on by ShanAbeywicrema

948

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

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Suggested answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,165 Moderator on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
ShanAbeywicrema 948 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,165 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 229 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,598 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

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

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
MazlumMomo 12 on at

Like (2)

Report
Copy link

Link copied!

Hello shan abeywicrema

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

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

Hope this helps.

CU,

Mazlum Momo

Was this reply helpful? Yes No
Suggested answer

KB-22080944-0 15 on at

Like (0)

Report
Copy link

Link copied!

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;

}

}

Was this reply helpful? Yes No
Suggested answer

Bjoern Waninger 4 on at

Like (0)

Report
Copy link

Link copied!

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 :-(

Was this reply helpful? Yes No