Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Suggested answer

Unable to run the report on the Sales Territory Entity

Posted on by
Hi Community,
 
We have an SSRS report that is working properly. It has the data related to the Account based on the Sales Territory so the user can select the territory on the filter and get all territory-related account details.
Currently we are directly running the report but we wanted to run the report by selecting the Sales territory. But in the Report configuration while selecting the entities there is not option to select the territory.
 
Please advise.
  • Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    Unable to run the report on the Sales Territory Entity
    Hi,
     
    You need to click the Report Wizard button to create the report.
     
    Then, you will be able to see the Territory entity.
     
     
    If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
    If you have further questions, please feel free to contact me .
     
    Best Regards,
    Dengliang Li
     
  • Amit Prajapati Profile Picture
    Amit Prajapati 156 on at
    Unable to run the report on the Sales Territory Entity
    Hi @Dengliang Li,
     
    I have tried all the permutations and combinations. My user has the System customizer role but still does not see the Terrirotry inside the setup of the report. Below is a screenshot for the same:
     
     
    Please let me know what needs to be done.
  • Suggested answer
    Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    Unable to run the report on the Sales Territory Entity
    Hi,
     
    Please check if you have permission to access the Terrority entity.
     
    If you do not have access to the Territory entity, you cannot create reports using the Territory entity.
     
    If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
    If you have further questions, please feel free to contact me .
     
    Best Regards,
    Dengliang Li
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans