Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS How to move a row group?

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

like image 308
salvationishere Avatar asked Oct 26 '11 21:10

salvationishere


People also ask

What is row group in Report Builder?

By default, when you add a table or list to your report, Report Builder and Report Designer automatically create the Details group for you, and adds a row to display the detail data. By default, when you add dataset fields to cells in this row, you see simple expressions for the fields, for example, [Sales].

How do I keep groups together in SSRS?

Select the Column Groups drop down, click "Advanced Mode" and then in Row groups highlight "Details". In Properties under the "Other" section, select "True" for Keep Together. and save.


1 Answers

[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.

like image 51
Jamie F Avatar answered Sep 27 '22 19:09

Jamie F