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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Show Sum only in Report
Microsoft Dynamics AX (Archived)

Show Sum only in Report

(0) ShareShare
ReportReport
Posted on by Community Member

hi, i want my report to show sum only

my current data:

name                 amount

name1                  2

name1                  3

name1total         5

name2                  1

name2                  2

name2total         3

-------------------

my desired result:

name              amount

name1total            5

name2total            3

i used sum in table field but it wont work, what should i do to make it sum only? do i need to change my query to sum or is there another way in visual studio ssrs? please help thanks.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,284 on at
    RE: Show Sum only in Report

    Hi RenSonozaki,

    If this report has data provider behind you can sum data in AX

    or another option is to do it directly in ssrs msdn.microsoft.com/.../ms170712.aspx

  • Community Member Profile Picture
    Community Member on at
    RE: Show Sum only in Report

    yes i would like to do it in ssrs instead of editing my dataprovider in ax.

    i already made the sum and the grouping, all i need to do now is to hide/remove the detail lines and show only the sum.

  • Community Member Profile Picture
    Community Member on at
    RE: Show Sum only in Report

    its done, just row visibility, very dumb of me. thanks for the answer ievgen.

  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,284 on at
    RE: Show Sum only in Report

    So you can simple delete details line from design or hide it setting Hidden = true in properties

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans