web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Reports: Grouping and ...
Microsoft Dynamics AX (Archived)

Reports: Grouping and Counting Records in a report

(0) ShareShare
ReportReport
Posted on by Arunkumar R 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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    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

  • Arunkumar R Profile Picture
    Arunkumar R 35 on at

    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?

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

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans