sqlreporting-servicesreportbuilder

How to group a text row in multiple data rows in Microsoft Report Builder

Basically I'd like to from this : What I have

To this : What I Want

Case in Orange are data that I pick up with an sql request while "This e-learning phase..." is just a plain text.
Does anybody knows how to do that ?

Solution

  • You could add a Parent Row Group and Group by the Information field.

    Unfortunately, this would place the Information on the Left side of the table. Fortunately, there is a Layout Direction property for the table that can be switched from LTR to RTL so that the table is created from Right to Left instead of the default Left to Right.

    enter image description here

    enter image description here

    enter image description here

    This way the grouped information field on the right would only have one cell while there may be multiple Activities.