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 / Customer experience | Sales, Customer Insights,... / SSRS Report - Can I ...
Customer experience | Sales, Customer Insights,...
Unanswered

SSRS Report - Can I merge the row cells after Sum up multiple rows by grouping

(0) ShareShare
ReportReport
Posted on by SSRS 5

Hi All,

I am looking for some hints to merge the row cells after sum of multiple rows in SSRS tabular report (2017V)

This is the report which  I have developed right now

pastedimage1591161710866v1.png

To get the Total Applied Amount I have used the below expression

=sum(Fields!AppliedAmount.Value,"ApplicationNo")

I am getting the correct Total Applied Amount but the problem is the total amount is spliting into two rows.

I need to get the ouput report as below.

pastedimage1591162511663v2.png

Any tricks to do it?

Please advice :) Thank you!!

I have the same question (0)
  • Vaibhav Shukla Profile Picture
    Vaibhav Shukla 120 on at

    Hello Rachana,

    A little change in your report design can fulfill your requirement.

    Please follow the steps as mentioned in this article :

    docs.microsoft.com/.../lesson-6-adding-grouping-and-totals-reporting-services

    Hope this helps! I'd appreciate if you'd mark this as a Verified answer.

    Thanks,

    Vaibhav Shukla

  • David Jennaway Profile Picture
    David Jennaway 14,065 on at

    You need to make sure the column for 'Total Applied Amount' is within the same row group as the columns 'Application No', 'Customer ID' and 'Name of Applicant'. I'm not sure if you'll be able to do this and keep the column on the right-hand side; you may need to move the column to the left of 'Applied Amount'. Or, it may be possible to apply the grouping and positioning that you want by directly editing the report xml

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 > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 170 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 70

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans