SSRS Data Table Layout

Hello~!

I am making a report. I want it to sort by Part Numbers, but have the Part Number column be second. I want [CurrLevel] to be listed as a the first column.

Like this:

image

In SSRS:

image

How can I make this happen?

Thank you.

Select the data table and go into it’s properties. Then add the two sorts you want under the sort tab.

1 Like

I see what you mean, but unfortunately that didn’t really work for what I needed it to do.

I ended up grouping it by Part, but hiding the column, then adding Level and then Part again, so it appears like Level | Part but it’s grouped by part number.

Thank you!