Post reply

SSRS 2014 : Add several cells inside of a large cell

  • December 7, 2015 at 4:22 am

    #305936

    I have created a table like below. The table use a dataset

    I want to add several cells within one of the row like below and be able to query through the same dataset and most of all, be able to leave the other rows intact (see below).

    Issue is I cannot do it within the table.

    One of my workaround solutions, which is not satisfying to me , is to to create a rectangle then add another table / matrix within that rectangle (like I did in the image above). Then superimpose the rectangle in one of the cell of the table / matrix I want to split. However, when I'm deploying the report, I have errors...

    The other solution is to create several columns then merge the cells of the rows I don't need and keep the cells I want. Drawback : Very tedious and lacking of flexibility

    If you have any ideas, I'm all ears.

    Thanks!

  • December 7, 2015 at 7:56 am

    #1844390

    @jonnus at found the answer

    It is doing what I was looking for.

  • December 7, 2015 at 8:14 am

    #1844397

    Can you do with an expression in the Naf_Eco cell where you format the output, something like

    =Naf_Eco + " " + Libel_Naf_Eco

    I guess it would depend how many fields and how complex the formatting but I have used this technique to combine values.

    Scott

  • December 8, 2015 at 2:01 am

    #1844571

    what you're looking for is a row group within the tablix

  • December 8, 2015 at 8:20 am

    #1844666

    Please find the answer in that link http://stackoverflow.com/questions/34131509/ssrs-2014-add-several-cells-inside-of-a-large-cell

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply