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

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,...
Active Discussion

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!!

  • 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 192 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 129

#3
CU11031447-0 Profile Picture

CU11031447-0 100

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans