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

0
votes

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

Design View

Report Preview

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 ?

1
reporting-servicesssrs-2008ssrs-2012ssrs-2008-r2ssrs-tablix
Do you mean you want Balance after Debit? What column are you grouping on? – Harry
@Harry Yes, I want Balance after Debit column. I am grouping on Date column – Hamzathussadique Mankarathodi

1 Answers

0
votes

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").