Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Reports: Grouping and Counting Records in a report

Posted on by 35

Hi All,

I wanted to count the total number of accounts in each industry and hence created a report with appropriate grouping. The report lists all accounts under each industry segment. There is also a count against each industry segment. But the problem is there are more than 250 pages of data. So if I needed to find the numbers in each industry segment, I will have to navigate each of those 250 pages. Is there any way in which the account names will not be displayed or can be minimized and I can see only the industry segments and the number of records in each industry segment?

For Ex:

Food & Beverages - 250

Oil & Gas - 300

Energy Generation & Distribution - 400

... etc.

*This post is locked for comments

  • Arunkumar R Profile Picture
    Arunkumar R 35 on at
    RE: Reports: Grouping and Counting Records in a report

    Hi Nitesh,

    Thanks for this. I have requested our IT guys to take this up. Is there no way to do this from within the CRM at the user level?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Reports: Grouping and Counting Records in a report

    Create drill down SSRS report

    Create report with Grouping

    On Group header create expression field to show the count which you need.

    SSRS is having enrich ways to do all these think... please explore more in SSRS report design.

    If you need more details, please explain more related to your issues and requirement

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans