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

Adding totals to Purchase Order RDLC Report

(3) Share

Report

Posted on by AK-13051749-0

290

Hello, can someone please guide me on how to add totals (subtotal, total discount, total tax, total amount) to the RDLC layout of the Purchase Order Report? (Report ID: 1322).

I tried using the TotalSubTotal, TotalInvoiceDiscountAmount, TaxAmount, and TotalAmount fields that are already defined in the standard report dataset, but the values are not being printed.

Any help will be greatly appreciated. Thank you.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

YUN ZHU 100,212 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, hope the following can give you some hints.

sum of a report layout field

https://learn.microsoft.com/en-us/sql/reporting-services/tutorial-step-06-add-grouping-totals-reporting-services?view=sql-server-ver17&wt.mc_id=DX-MVP-5004336%3Fview%3Dsql-server-ver17

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Kamal Khakhkhar 3,347 on at

Like (1)

Report
Copy link

Link copied!

Hii There as per requirement you can go through below links for reference .

as per @YUN ZHU suggested links you can also check that for get the working for total.

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/add-a-total-to-a-group-or-tablix-data-region-report-builder-and-ssrs?view=sql-server-ver17

https://archerpoint.com/grouping-rdlc-report-microsoft-dynamics-nav-or-business-central/

if you found answer , please Mark this answered.

Thank You.

Kamal Khakhkhar

Was this reply helpful? Yes No
Suggested answer

Yash_Mistry 474 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Have you tried checking how the values are calculated in the base report by debugging in VS Code? There might be a case where the values are not calculated initially. First, check that in the report through debugging, and if it is still blank, feel free to ask me.

Regards,
Yash Mistry

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 15,190 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Most likely the issue is scope, not the dataset fields themselves. In report 1322, fields like TotalSubTotal, TotalInvoiceDiscountAmount, TaxAmount, and TotalAmount can exist in the dataset, but in RDLC they often won’t print if the textbox is placed inside the wrong data region/group or if the expression is evaluated at line scope instead of header scope. First, run the report with Send to > Microsoft Excel Document (data only) or XML (data only) and confirm those four fields actually contain values for your document; if they do, then in the RDLC layout place the totals outside the repeating line tablix or use the correct aggregate/scope expression for the parent data item, otherwise the textbox may stay blank. If the dataset export shows those fields are empty, then the standard dataset isn’t populating them in your scenario and you’ll need a report extension/custom dataset change rather than only an RDLC edit. Microsoft’s docs don’t give a report-1322-specific formula here, but they do recommend validating the raw dataset first when a layout shows blank values, which is exactly the right next step.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No