Multi-column report with one column of labels

Posted by: pauld on 29 October 2021, 11:11 am EST

  • Posted 29 October 2021, 11:11 am EST

    We need to create a report with multiple columns with item labels arranged vertically down the left side, but I don't see a clean way to do it.

    Here is a crude diagram of the layout:

    Col1 Col2 Col3
    Age: 19 44 55
    Height: 6' 7' 8'

    The problem with using the innate multi-column capability is that it places data in all the columns and doesn't allow for the item labels on the left, as far as I know.

    I guess I could have a subreport with multiple columns and have the labels in the main report, taking special care to get them lined up across the main report and the subreport.

    Is there a way to achieve this layout without bending reports out of shape?


    – Paul
  • Replied 29 October 2021, 11:14 am EST

    Because all the leading spaces in the original post were eaten, pretend the underscores in this version are empty spaces.

    Here is a crude diagram of the layout:

  • Replied 31 October 2021, 6:15 pm EST


    You can use Tablix for the same. You can use RowGrouping for each column. Please refer to the following link:

  • Replied 1 November 2021, 7:38 am EST


    I have never used Tablix and, after playing around, I could get it to work, with one little hitch.
    My design:
    1st column: A series of text boxes with their values hard-coded to descriptions of what each data item in the row is.
    2nd column: A series of text boxes with their values set to field names from the dataset.

    When the report is previewed:
    * The first column in the grid is displaying my hard-coded text descriptions.
    * The remaining grid columns are properly displaying the dataset rows as columns in the grid.

    My problem is that:
    * The 1st page correctly displays the Tablix as positioned horizontally in the designer.
    * Subsequent pages show the Tablix flush against the left hand edge of the page.

    Further, the text box containing "Report Tablix" only appears on the first page.

    What could be causing this?

    -- Paul

  • Replied 1 November 2021, 3:24 pm EST


    >>What could be causing this?
    It is caused because Tablix grows horizontally which render on multiple pages. Technically, it renders the report on a single page in case of RDL report then split it into the pages.

    You can check after changing the View mode of viewer to "Galley Mode".

    I suggest you to use the PageReport instead of RDL which will solve your issue.

  • Replied 2 November 2021, 10:05 am EST


    When I use a PageReport, it only display one record per page.
    What I want is multiple records per page, however many will fit.

    -- Paul
  • Replied 2 November 2021, 4:24 pm EST


    You need to increase the Fixed size of the Tablix.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels