Invoice RDLC lay-out, how to group quantity and amount per line on item, in Microsoft Report Builder every field is a text :(

(0) Share

Report

Posted on by BrutusG

155

Hello,

We have an invoice with the same Item on 3 lines. I want to group per item on the invoice. HOw do I do that?

I want to change the RDLC invoice lay-out. I want to group lines based on items and get totals on quantity, amount and discount. When I export the standard 1306 built-in RDLC lay-out all fields are text fields. I tried several things like FormatNumber combined with SUM but that gives an error. Does any one how to solve this without creating a complete extension for the built in lay-out?

Thank you in advance!

What is the way to go about this?

Thank you in advance!

All responses (1)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

RE: Invoice RDLC lay-out, how to group quantity and amount per line on item, in Microsoft Report Builder every field is a text :(

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.