News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Reports: Grouping and ...

Microsoft Dynamics AX (Archived)

Reports: Grouping and Counting Records in a report

(0) Share

Report

Report

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

All responses Img

All responses (2)

Answers Img

Answers (0)

Arunkumar R 35 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans