4
votes

I am using SSRS 2008 and I created a tablix with several groupings. However, I see now that my latest grouping is below the details. This was a mistake because I should have all groupings in my tablix preceding my details group. All of my groups are adjacent to each other. How to reposition this group so that it precedes details group instead?

Separate note: is there a way to merge cells for a range of rows? I only know how to merge cell one row at a time! And is there a way to copy n rows? Or do I have to copy one row at a time?

Yes, the row group is actually below the Details group. See attached images. enter image description here

enter image description here

1

1 Answers

7
votes

[Essentially deleting previous post on this. It was based on a bad assumption.]

I would insert a new group where appropriate, then delete cells and columns as appropriate to get the rows for the two groups to match in number: then you can copy and paste the cells (many at once) from the old group to the new.

Make sure that your grouping formulas or fields match and then delete the old group.

(You probably already discovered this, but a clean easy way to create groups is by dragging fields from "Report Data" to the "Row Groups" subwindow: this method will refuse to create a group below details.)

I think the only alternative is to edit the XML and that is dangerous: be careful and keep old versions to revert if needed.