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

How to add a dataitem to Report Extension?

(1) Share

Report

Posted on by jdrco

479

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?

All responses (11)

Answers (0)

jordihayes 2 on at

Like (0)

Report

How to add a dataitem to Report Extension?

I know this is an old thread, but this solved my problem. To add a child data item use "AddFirst" or "AddLast".

Actually "AddFirst" is more like "AddFirstInto", and "AddLast" is more like "AddLastInto".
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
Suggested answer

YUN ZHU 75,561 Super User 2024 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
jdrco 479 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
jdrco 479 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")

{

}

}

}
Suggested answer

tanya07 1,548 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
Suggested answer

tanya07 1,548 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
jdrco 479 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.
Suggested answer

Arjun Anand 175 on at

Like (0)

Report

RE: How to add a dataitem to Report Extension?

Please check the below screenshots:
Suggested answer

tanya07 1,548 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