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.
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].
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.
[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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With