Disable cell merging in row group in SSRS

merge cells in ssrs using expression
ssrs merge cells
ssrs merge rows vertically
how to merge two rows cells in ssrs report
ssrs export to excel merged cells issue
ssrs export to excel adds extra rows
ssrs repeat group value each row
ssrs export to excel issues

I've created several reports in SSRS. For example, I have report which shows number of people in cities grouped by sex.

If I export this report to Excel, the City column is merged over its whole group.

----------------------------------------------------------------
| City                | Sex             | Population           |
| ============================================================ |
|                     | men             | 5582                 |
|                     | -------------------------------------- |
| The Big City        | women           | 5468                 |
|                     | -------------------------------------- |
|                     | total           | 11350                |
| ------------------------------------------------------------ |
|                     | men             | 1609                 |
|                     | -------------------------------------- |
| The Small City      | women           | 1564                 |
|                     | -------------------------------------- |
|                     | total           | 3173                 |
----------------------------------------------------------------

But I have to filter data in Excel. For example find number of womens in Big City. This is not possible with merged cells. So I want this.

----------------------------------------------------------------
| City                | Sex             | Population           |
| ============================================================ |
| The Big City        | men             | 5582                 |
| ------------------------------------------------------------ |
| The Big City        | women           | 5468                 |
| ------------------------------------------------------------ |
| The Big City        | total           | 11350                |
| ------------------------------------------------------------ |
| The Small City      | men             | 1609                 |
| ------------------------------------------------------------ |
| The Small City      | women           | 1564                 |
| ------------------------------------------------------------ |
| The Small City      | total           | 3173                 |
----------------------------------------------------------------

I've found one possible solution here. Add following grouping expression to City row group properties.

=Fields!City.Value & Fields!Sex.Value

But I'm not satisfied with this solution. Reports are generating much more longer now, because report is generated from 3 - 4 millions of records. This is not acceptable for our customers.

How can I disable cells merging in row group?

Many thanks!

I found a really good solution to this which is going to group properties and group on the cell you want to merge. So right click City under your row groups and on the group expression you group on sex, instead of grouping on city. At least that worked for me.

How to remove cell merging in row group in Reporting Services , By the catch here is that when you use a matrix with row groups over more than one column (you have three groups over three different columns)  How to remove cell merging in row group in Reporting Services’ Matrix Component Technorati Tags: Reporting Services , SQL Server , Matrix , Excel Today I received a request for report that was in general a detailed table of some data from the DWH database, but with dynamic number of columns.

A little late, but these steps worked for me:

  1. Create the groupings per usual so that city is in a group as in the above.

  2. Create a new "City" column by inserting a column to the left of the current "Sex" that is still within the "details" grouping.

  3. Delete the original "City", but do not delete its group. In the "Grouping" tab at the bottom of the page you should still see (City) as a group.

I did not notice any changes to performance using this solution even with a very large dataset.

Hope this helps!

Cells, Rows, & Columns in a Tablix, Dear reader, thanks for visiting! The post has been moved to my new blogging site - www.mssqlinsider.com. You can read the complete post  Lets be completely direct here. Cell merging in Sql Server Reporting services after exporting to Excel, is a common nightmare. It happens because the engine that transforms the report tries to do so on a presentation basis. I have been developing reports in SSRS for a few years now, and here are the best ways around the issue that I have found: 1.

Instead of doing your groups and sum on the design/presentation side, you could modify your sql so that grouping and totals are done on the dataset. Since you are then not grouping any of the rows, the table should export out to Excel as individual sells and not merged cells.

Group on Rows but do not Merge ? [ RS 2008 ] - MSDN, SQL Server Reporting Services, Power View I have a matrix report with 4 row groups [ parent - child ] when ever i group on the parent To prevent the parent row group cells from being merged in the matrix, you just need to  Right click row->Row Group->Group Properties Then, in tab "General" Choose "group on" belows "add" and "delete" buttons and click delete to remove group ->OK. Right Click at the first column of Matrix and choose "Delete Column" option.

How to Eliminate Excel Column Merging in Exported SSRS Reports , Exporting the report to Excel produces the worksheet below, where columns A and B are separate in Rows 1 to 3, but merged from row 4. A2 4 6  Cells, Rows, & Columns in a Tablix Data Region (Report Builder) and SSRS. 12/16/2019; 8 minutes to read +2; In this article. To control how the rows and columns of a tablix data region display data in a Reporting Services paginated report, you must understand how to specify rows and columns for detail data, for group data, and for labels and totals.

How To Remove SSRS Merged Columns, I show you how to remove unwanted merged columns and rows from an when SSRS exports Duration: 4:48 Posted: Sep 29, 2013 in visual studio, below design box, you can find row groups & column groups, right side of column group you can find down arrow, if you click on that you will find [ advance mode] once it is opened, right click on the first row group, click group property, select visibility , click on hide. Done, Pl check

SSRS Merge Data Across 2 Group Values, I've read other posts about creating an additional row in the table which has 2 cells merged together, using an expression to hide this row when it is not used  To merge cells in a data region. In the data region on the report design surface, click the first cell to merge. Holding the left mouse button down, drag vertically or Right-click the selected cells and select Merge Cells . The selected cells are combined into a single cell. Repeat steps 1 and 2

Comments
  • Well, I think the whole thing about SSRS reports is separting view from business logic, so I guess it's not a solution for this case.