7

I am trying to achieve the following layout for my report based on one query.

+----+-------+----+-------+
| ID | Name  | ID | Name  |
+----+-------+----+-------+
|  1 | Danny |  2 | Dave  |
|  3 | Sue   |  4 | Jack  |
|  5 | Rita  |  6 | Sarah |
+----+-------+----+-------+

So I basically want one table, printing my data from left to right to save space on my page, rather than it printing one line and wasting all of the space on the right side of the paper, possibly even go 3 times across the width.

This is my data: http://sqlfiddle.com/#!3/5c911/1

I was maybe thinking a table with 4 columns. Cols 1 and 2 contain the odd row numbers, Cols 3 and 4 contain the even row numbers.

How could I achieve this, I did try something with the MOD function but it didn't seem to work properly, or I misunderstood what was happening.

Related: How can I display two rows worth of data on one line side-by-side in Report Designer?

Thanks,

Community
  • 1
  • 1
Danny Cullen
  • 1,782
  • 5
  • 30
  • 47
  • Can you edit the question and add details on your dataset, what you've tried so far, and specifically (in addition to the *sample*) what you're trying to achieve? – Jeroen Dec 05 '12 at 11:44
  • Sorry, I've added some more detail now. – Danny Cullen Dec 05 '12 at 13:19
  • Have you considered using the report *Columns* property: http://stackoverflow.com/questions/6269808/ssrs-am-i-hallucinating This will use multiple columns for .pdf output but not for web and Excel, which might be exactly what you want. – Jamie F Dec 05 '12 at 18:25

2 Answers2

8

To print your data from left to right in a multi-column format, you need to fake it using multiple tables. To implement this hack, create the same number of tables as columns you want side by side that all point to your data set. On the Detail row of the first table, for the Visibility-Hidden property use the following formula:

=IIF((RowNumber(Nothing) Mod 4) = 1, False, True)

where 4 is the number of tables (columns) you have.

Do the same for each table, incrementing what the formula is equal to (so for the second column (RowNumber(Nothing) Mod 4) = 2 and so forth). In the last table (column) the formula equals 0.

This alternately hides the detail row, only displaying the appropriate rows for that column number.

Chris Latta
  • 20,316
  • 4
  • 62
  • 70
0

You can achieve that look with query. 

SELECT std1.id AS Student_Id, 
        std1.NAME AS Student_Name, 
        std2.id AS Student_Id, 
        std2.NAME AS Student_Name
FROM students std1, students std2
WHERE (std2.id - std1.id = 1 
       AND std1.id %2 = 1);
Farhat Ullah
  • 79
  • 2
  • 9