Skip to main content

Notifications

Business Central forum
Suggested answer

SalesPerson Report Customization Customer Name Issue

Posted on by 6
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.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 62,529 Super User on at
    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)
    Dynamics 365 Business Central: How to add Media or MediaSet data type (Pictures) to a report
    Dynamics 365 Business Central: How to print all type of lines in standard Pro Forma Invoice report – Customization
     
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 6,135 Super User on at
    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.
     
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 12,769 User Group Leader on at
    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
  • gdrenteria Profile Picture
    gdrenteria 4,046 Super User on at
    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
    BR
    GR

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284,217 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,202 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans