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

How to add a dataitem to Report Extension?

(1) Share

Report

Posted on by jdrco

481

After using add() to an existing dataitem on my report extension, I've noticed that I can't add another data item after using that command (add()).
How do I add another dataitem to a report extension?

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

RE: How to add a dataitem to Report Extension?

Hi,

Please refer the below link

docs.microsoft.com/.../devenv-report-ext-example

Was this reply helpful? Yes No
Suggested answer

tanya07 1,638 on at

Like (0)

Report

RE: How to add a dataitem to Report Extension?

Hi, jdrco,

Please use addafter() to add another dataitem.

Thanks,

tanya kharbanda

Was this reply helpful? Yes No
Suggested answer

Arjun Anand 202 on at

Like (0)

Report

RE: How to add a dataitem to Report Extension?

Please check the below screenshots:

Was this reply helpful? Yes No
jdrco 481 on at

Like (0)

Report

RE: How to add a dataitem to Report Extension?

Where can I get a more in depth explanation of dataitemlink? Still not sure what that does.

Was this reply helpful? Yes No
Suggested answer

tanya07 1,638 on at

Like (0)

Report

RE: How to add a dataitem to Report Extension?

Please check the below -

docs.microsoft.com/.../devenv-dataitemlink-reports-property

Was this reply helpful? Yes No
Suggested answer

tanya07 1,638 on at

Like (1)

Report

RE: How to add a dataitem to Report Extension?

Hi,

In the below example if you see, I have added dataitemlink where in -

ItemAttributes."No." field is linked to Sales Invoice."No"

For more queries, please share your code.

Thanks,

TK

Was this reply helpful? Yes No
jdrco 481 on at

Like (0)

Report

RE: How to add a dataitem to Report Extension?

Hi tanya07 , thanks for your active help. What I am trying to do create a report extension for the Customer Statement that:

- gets the shipping information of the customer from the Sales Invoices or Posted Sales Invoices that is related to the current customer

- get Sales Invoice Line information from all of the Posted Sales Invoices of the specific customer

Here is my code for the first bullet so far in the report extension after the add() command:

addlast(Customer)

{

dataitem("Sales Header"; "Sales Header")

{

DataItemTableView = sorting("Document Type", "No.");

DataItemLink = "Sell-to Customer No." = field("No.");

column(ShipToName; "Ship-to Name")

{

}

}

}

Was this reply helpful? Yes No
jdrco 481 on at

Like (0)

Report

RE: How to add a dataitem to Report Extension?

When I do this, the fields come up blank when try to render the report

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 94,331 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to add a dataitem to Report Extension?

Hi, just adding some info from MS.

More details: https://yzhums.com/10723/

Hope this also helps.

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

Community member 2 on at

Like (0)

Report

How to add a dataitem to Report Extension?

Hi,

1. Create a report extension

2. Add your/required dataitem under correct Parent (you can use: addafter, addlast, addfirst).

3. Add columns and logic (under triggers).

4. Publish your extension

5. Create a new layout/copy existing layout.

Watch out for parent dataitem propery UseTemporary=true. If this is the case, add a new similar dataitem and put child there.

Hope this helps.

RO

Was this reply helpful? Yes No