SQL Reporting Services - 从左到右，向上和向下分配

Is there a way in SQL Reporting 2005 to display data in a column that prints left to right then up and down? Example:

SQL Reporting 2005中是否有一种方法可以在从左到右然后上下打印的列中显示数据?例:

Column 1        Column 2

  Adam            Bob
  Carl            Dick
  Eric            Fred

Instead of the current way which is:

而不是当前的方式是:

 Column 1        Column 2

  Adam            Dick
  Bob             Erick
  Carl            Fred

Thank you.

2 个解决方案

#1

Horizontal tables ...?

水平表......?

#2

3 ways I can think of.

我能想到的三种方式。

Nothing pretty or natural though. The problems are that there is no standard control in SSRS, and there is no control data to use to manage layout in a standard control

没什么好看或自然的。问题是SSRS中没有标准控制,并且没有控制数据可用于管理标准控件中的布局

First, Generate a dummy column, say using ROW_NUMBER() and modulo 2. Use this to filter the dataset results into 2: bind each filtered set to side by side tables.

首先,生成一个虚拟列,例如使用ROW_NUMBER()和modulo 2.使用此过滤器将数据集结果过滤为2:将每个过滤后的集合绑定到并排表。

Second, use a matrix control in a rectangle This will split pairs of rows about to side by side, use the rectangle grouping to split into pairs. You'll need a dummy column again to group on but going up 0, 0, 1, 1, 2, 2 (hmmmm how to do that...)

其次,在矩形中使用矩阵控件这将并排分开成对的行,使用矩形分组成对。你需要再次使用一个虚拟列进行分组,但是要上升0,0,1,1,2,2(嗯,该怎么做......)

Third, generate the dataset as 2 columns. Self-join or PIVOT using a ROW_NUMBER() and modulo 2 column

第三,将数据集生成为2列。使用ROW_NUMBER()和modulo 2列自我加入或PIVOT

Personally I'd tend to the 3rd option or 1st option.

就个人而言,我倾向于第三种选择或第一种选择。

#1