show one column in three columns in SSRS
<p>I have a SSRS report which shows the different number of records based on the parameters. the result is two columns but 60 rows or more, I tried to show my dataset result in six columns instead of two columns to be more user friendly and to utilize the empty space.
I have three <code>tablix</code> and each <code>tablix</code> points so same dataset and same columns but I applied this expression on the <code>row visibility</code>
first <code>tablix</code>'s expression is</p>

<pre><code>=IIF((RowNumber(Nothing) Mod 3) = 1, False, True)
</code></pre>

<p>the second <code>tablix</code>'s expression is</p>

<pre><code>=IIF((RowNumber(Nothing) Mod 3) = 2, False, True)
</code></pre>

<p>the last <code>tablix</code>'s expression is </p>

<pre><code>=IIF((RowNumber(Nothing) Mod 3) = 0, False, True)
</code></pre>

<p>the result I get is</p>

<pre><code>T01 65       T02 85         T03 21
T04 85       T05 89         T06 85
T07 87       T08 85         T09 85
</code></pre>

<p>Is there any way I can show my result as :</p>

<pre><code>T01 65       T04 85         T07 87
T02 85       T05 89         T08 85
T03 21       T06 85         T09 85
</code></pre>