Hi
I have a dataset with 2 columns, a rownumber and a servername - eg
rownumber servername
1 server1
2 server2
....
15 server15
I want to display the servernames in a report so that you get 3 columns - eg
server1 | server2 | server3
server4 | server5 | server6
...
server13 | server14 | server15
I have tried using multiple tables and lists and filtering the data on each one but this then makes formating very hard - i either end up with a huge gap between columns or the columns overlap
I have also tried using a matrix control but cant find a way to do this.
Does anybody know an easy way to do this? The data comes from sql 2005 so i can use a pivot clause on the dataset if somebody knows a way to do it this way. The reporting service is also RS2005
Thanks
Anthony
dont you hate it when you figure out the solution just after you have asked the question.
Here is how i managed to do it if anybody else is interested.
First put the data in a matrix control so you have all the servernames on one row.
Then add a list control and put the matrix in the list control.
Finally set the grouping expression on the list control to be
=Ceiling(RowNumber(Nothing)/3)
Anthony