Multi-column report with one column of labels

Multi-column report with one column of labels

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

• 

  pauld

  • Post Options:
  • Link
    Copy

  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
  

  Name: AAA BBBB XXCCC
  
  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?

  Thanks.

  – Paul

• 

  pauld

  • Post Options:
  • Link
    Copy

  Posted 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:

  _________Col1___Col2___Col3
  
  Name:___AAA__BBB___CCC
  
  Age:_______19____44_____55
  
  Height:_____6’____7’______8’

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 31 October 2021, 6:15 pm EST

  Hello,

  You can use Tablix for the same. You can use RowGrouping for each column. Please refer to the following link:
  
  https://www.grapecity.com/activereportsnet/docs/v15/online/tablix.html

  Thanks,
  
  Mohit

• 

  pauld

  • Post Options:
  • Link
    Copy

  Posted 1 November 2021, 7:38 am EST - Updated 30 September 2022, 6:22 am EST

  Mohit,

  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

  
  
  

  

  824×253 29.5 KB

  
  
  

  

  823×236 28.6 KB

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 1 November 2021, 3:24 pm EST

  Hello,

  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.

  Thanks,
  
  Mohit

• 

  pauld

  • Post Options:
  • Link
    Copy

  Posted 2 November 2021, 10:05 am EST

  Mohit,

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

  Thoughts?
  
  – Paul

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 2 November 2021, 4:24 pm EST

  Hello,

  You need to increase the Fixed size of the Tablix.

  Thanks,
  
  Mohit