News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to remove duplicat...

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

Suggested answer

How to remove duplicate values in rdlc report in business central

(0) Share

Report

Report

Posted on by Nilam Bhor

153

Hi Guys,

For example: I have 3 fields. i.e. no,description, quantity.

in my no field ,i have the duplicate values.& also description have same values.

I want ,that 2 same entry ,should i get in one entry.as shown in below image.i.e. result.

And that same entry have quantity also , so i want sum of that quantity as shown below image.

.

Is there is any way to do this.

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Steven Renders 5,512 Moderator on at

Like (0)

Report

RE: How to remove duplicate values in rdlc report in business central

Add a group in the tablix on the No field, then calculate the Sum(Quantity).

Add an RDLC layout to a report - Training | Microsoft Learn

Walkthrough: Designing a Report from Multiple Tables - Business Central | Microsoft Learn

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Sohail Ahmed 2,655

#2

Mansi Soni 1,574

#3

YUN ZHU 1,453 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans