How to change the position of on of the Grouped columns in SSRS

Question

I was creating an SSRS report show customer ledger. I wanted to merge the cells of Date, Mode and Balance columns for same dates. I did it using the row grouping. Screenshots are given below.

Design View

Report Preview

But I couldn't change the position of 'Balance' column to the right end as Customer requested. Is there any way to reposition it to the right ?

Do you mean you want Balance after Debit? What column are you grouping on? — Harry, May 27 '18 at 22:04
@Harry Yes, I want Balance after Debit column. I am grouping on Date column — Hamzathussadique Mankarathodi, May 28 '18 at 07:26

score 0 · Answer 1 · answered Jun 09 '18 at 02:53

0

After the debit column insert a column. Insert an expression in the following format: =RunningValue(Fields!Credit.Value,SUM,"Tablix1") - RunningValue(Fields!Debit.Value,SUM,"Tablix1").

answered Jun 09 '18 at 02:53

SuperSimmer 44

964
2
7
12

How to change the position of on of the Grouped columns in SSRS

Design View

Report Preview

1 Answers1