SSRS - How to indent row based on a condition?

Question

In SSRS, I have a report for example:

Designation                Type          Amount

Admin1                     Gift           50
Admin1                     Payment        50
Admin1                     Payment        50
Admin2                     Gift           100

So basically Admin1 can receive a gift of $50 for example, and any additional payments made toward this same designation will be classified as a payment from then on, and I'd like to left indent the corresponding payments relating to the initial gift to look like so:

Designation                Type          Amount

Admin1                     Gift           50
     Admin1                Payment        50
     Admin1                Payment        50
Admin2                     Gift           100

My logic would be something like if the Designation is the same, and the Designation has a Type of Payment, then these have to be indented underneath the same Designation where the Type is Gift.

I've never worked with indentations before in SSRS, Is this possible to do?

score 1 · Answer 1 · answered Aug 20 '20 at 21:46

1

You could do this in SQL as:

select (case when type = 'Payment' then concat('     ', designation)
             else designation
        end) as designation, type, amount
from t
order by designation, type;

There may be a completely different method in SSRS.

answered Aug 20 '20 at 21:46

Gordon Linoff

1,242,037
58
646
786

I never thought about doing it via SQL, I may try that as well. Your above code only is checking for Type = 'Payment' but it doesn't also check to make sure the Designation is the same as well right – jwalls91 Aug 20 '20 at 22:08
@jwalls91 . . . That didn't seem to be part of your question. – Gordon Linoff Aug 21 '20 at 02:19

score 1 · Accepted Answer · answered Aug 21 '20 at 14:04

You will need to add a row group to your report that groups by Designation. If you currently only have a 'details' row group then right-click it and add a parent group. You can delete the new column if one is generated,, but do not delete the group.

Let's assume when you create this row group that you called it grpDes

Next, in the textbox you need to adjust, click it and in the properties panel, find "padding" and expand it out, click the drop down in "left" and choose "expression".

Set the expression to something like

=IIF(ROWNUMBER("grpDes") >1 AND Fields!Type.Value = "Payment", "10pt", "2pt")

Adjust the 10pt to whatever you want...

Note that the group name must be enclosed in quotes and is case sensitive.

So what this does is, groups the data by designation, then checks the row number within each group. If the row is not the first group with in the group AND the type is "payment" then set the padding to 10 point otherwise set it to 2pt (SSRS default)

SSRS - How to indent row based on a condition?

2 Answers2