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
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.
Any tricks to do it?
Please advice :) Thank you!!
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
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
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
