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

SalesPerson Report Customization Customer Name Issue

(1) Share

Report

Posted on by SM-17051434-0

In the Salesperson commission report there was a field called Customer where the customer number is present.

But I want, Instead of Customer Number the Customer name should be coming.

I'm doing the report customization in RDLC.

In my Microsoft report builder there was a dataset consist of Cust_Ledger_Entry__Customer_No__ field.

How to resolve that issue.

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (0)

Suggested answer

YUN ZHU 86,125 Super User 2025 Season 1 on at

Like (2)

Report

SalesPerson Report Customization Customer Name Issue

Just adding some Report Extension examples, hope it can give you some help.

Dynamics 365 Business Central 2021 release wave 1 (BC18): Report extensibility (ReportExtension Object)

https://yzhums.com/10723/

Dynamics 365 Business Central: How to add Media or MediaSet data type (Pictures) to a report

https://yzhums.com/38137/

Dynamics 365 Business Central: How to print all type of lines in standard Pro Forma Invoice report – Customization

https://yzhums.com/50866/

Thanks.

ZHU
Suggested answer

Valentin Castravet 28,290 Super User 2025 Season 1 on at

Like (1)

Report

SalesPerson Report Customization Customer Name Issue

Saurav.Dhyani is correct. You need to add the field to the report dataset and then to the layout.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Suggested answer

Saurav.Dhyani 14,322 Super User 2025 Season 1 on at

Like (2)

Report

SalesPerson Report Customization Customer Name Issue

Hi,

As the field is not part of dataset. You will have approach like this -

1. Using Report Extension you need to add Customer Name in Dataset.

2. Once added in dataset you can create a new layout (copy of existing) and all your new column as needed.

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube
Gerardo Rentería Ga... 20,957 Most Valuable Professional on at

Like (2)

Report

SalesPerson Report Customization Customer Name Issue

Hi

You can add the customer name field from table 21.I give you some links that show you how to extend the report

How do I: Create a Report Extension to add a field to the dataset of a Report? – think about IT

(1) Adding fields to reports with ReportExtensions in AL and Business Central - YouTube

BR

GR