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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Add group by in ssrs r...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Add group by in ssrs report expression

(1) ShareShare
ReportReport
Posted on by Menna Allah Ahmed 163
I have 4 lines of this job 2 lines in position and 2 lines in customize table , so now I am creating ssrs report and I added group by job so I get in report 2 lines also in this table I have contarct column and I added 10 , 70 value on it .
I need to get sum of this contract as 80 not 160 How can I do it ? I need column to see only rows in group not all rows 
I tried this way but I got an error
 
 
 
//
//
//
I have the same question (0)
  • Suggested answer
    Community member Profile Picture
    Community member 36 on at
    Hi Menna,
     
    Instead of changing it in report design - You can control it from the code (Dp class) - Change report table type as regular - Add validation to restrict duplicate records before inserting into a report table.
    At starting of the processReport method use delete_from table to delete the previous records.
     
    Thanks,
    Girish S.
  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,565 Moderator on at
    Hi Menna, Since its showing double value, the easy work around would be to display half of sum value by dividing by 2. Try below formula in SSRS textbox expression. Otherwise,as Girish mentioned you can handle it in code level as well 
     
    SUM(MAX(Fields!ContractNumber.Value),"JobID")/2
     
    Thanks,
    Mohit
  • Saud Jalil Profile Picture
    Saud Jalil 34 on at
    You should group your data in Data Provider class,
    in X++ you can add group by after Where clause

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans