How to remove cell merging in row group in Reporting Services’ Matrix Component

Dear reader, thanks for visiting!

The post has been moved to my new blogging site – http://www.mssqlinsider.com.

You can read the complete post there.

Advertisements

8 comments on “How to remove cell merging in row group in Reporting Services’ Matrix Component

  1. Ivan,
    I can’t tell you how much time this has saved, it has been the top of my list of annoying things I can’t fix for ages! It is so simple that I am kicking myself.
    Thanks!

  2. Ivan –

    Fantastic! Probably a year or two ago I ran into this problem and didn’t figure it out… because of your blog this time it is solved in no time at all.

    Thanks a ton!!
    Eric

  3. thank you worked for me too. just added to the grouping expression to include all similar columns and one unique column. Only had to do it on the parent row grouping.

  4. I’ve tried this method & it didn’t work. I’m using BIDS 2010 that came with Denali.

    I have 4 fields I need to concatenate but anything more than 2 fields in the grouping formula & I get an invalid definition error. Even using just 2 fields, it ignored it anyway and displayed merged cells with the wrong information. I started the matrix from scratch & got the invalid definition error again.

    Any ideas?

  5. Thank you for sharing this solution. I have a similar issue but, instead of merged rows, I’d like to overcome a similar problem with merged columns.
    The need to use a matrix is that the columns are dynamically generated based on the data set. Due to the indeterminate amount of columns I cannot set up the solution described in this post.
    I would be grateful if anyone has a similar issue that they’ve solved. A simple matrix property setting in SSRS would have been a no-brainer – but no such luck.

  6. This solution is great. But it works perfectly fine when you dont have Subtotal field on one of the Row Group columns, in your case Status or Vendor ID. Do you know if there is a way to remove merging for the Row Group which has subtotal field added in the report?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s