matrix or table that adds a new column after 5 rows are filled with data

• jorg_klein

  SSC Enthusiast

  Points: 116

  More actions

  November 22, 2007 at 3:54 am

  #122459

  Hello,

  I have a report in wich I show a list of countries. The length of this list differs each month and comes from a SSAS datasource.

  I want to show this list on my report in a matrix like this:

  country1 country6 country11

  country2 country7 country12

  country3 country8

  country4 country9

  country5 country10

  How can I do this? I need some sort of check that counts the number of countries added and then adds a new column after 5 countries.

  I'm sure there is somebody that did this or knows how to do this.

  Thanks in advance!

  Jorg.

  ---------------------------------------------------
  My Microsoft Business Intelligence blog: http://sqlblogcasts.com/blogs/jorg/

• Jon Spink

  SSCarpal Tunnel

  Points: 4010

  More actions

  November 23, 2007 at 1:45 am

  #753551

  You need to use a table, not a matrix, and set the number of columns to, say, 3.

• jorg_klein

  SSC Enthusiast

  Points: 116

  More actions

  November 23, 2007 at 8:50 am

  #753651

  I fixed this problem.

  Find the solution here:

  http://forums.microsoft.com/msdn/ShowPost.aspx?postid=2451583&isthread=false&siteid=1&authhash=66929c747f931a54531d55bc077dd26e6094848b&ticks=633314009276672864

  Jorg

  ---------------------------------------------------
  My Microsoft Business Intelligence blog: http://sqlblogcasts.com/blogs/jorg/