Adding a line break in a table column

• al3408

  Old Hand

  Points: 302

  More actions

  August 19, 2015 at 12:12 pm

  #299788

  In one of my reports I'm trying to display the output of the data horizontally as opposed to vertically. The problem is if the list of columns extends beyond the page margins the rest of the columns will display on another page, instead of doing what I want it to do which is continue on the next line of the same page.

  So if I have an output of 20 columns I would like it to show 10 on each line. Any ideas how I can add a line break to make this happen?

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  August 19, 2015 at 12:40 pm

  #1821158

  One option might be to create two separate matrices with the same grouping and stack them.

  got any dummy data for us to play with? (either create table and insert scripts or a union query)