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

How to add a dataitem to Report Extension?

(1) Share

Report

Posted on by jdrco

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)

Suggested answer

Nitin Verma 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
Suggested answer

tanya07 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
Suggested answer

Arjun Anand on at

Like (0)

Report

RE: How to add a dataitem to Report Extension?

Please check the below screenshots:
jdrco 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

tanya07 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
Suggested answer

tanya07 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
jdrco 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")

{

}

}

}
jdrco 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
Suggested answer

YUN ZHU 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
Suggested answer

Community member 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