August 25, 2010 at 11:45 am
Hi all. needing some assistance here. I'm creating a fairly simple report that displays a list of reports. It only has two culmns, one for the ClientID and the other Client Name.
How can I have this report display two sets columns?
I'm trying to make it look like this on one page:
ClientID......ClientName..................ClientID......ClientName
1..................Name1........................7............Name7
2..................Name2........................8............Name7
3..................Name3........................9............Name7
4..................Name4.......................10............Name7
5..................Name5.......................11............Name7
6..................Name6.......................12............Name7
If list overflows to additional pages, then it will continue with Client 13 and then so on.
Hope this explaination was clear.
Thanks for the help.
August 25, 2010 at 12:15 pm
I did this once for a 1-column report (long list of parts), which I actually displayed as 10 rows across. I did this by adding two fields to the data set:
FLOOR((ROW_NUMBER() OVER (ORDER BY PartID)-1) / 10) AS Row,
(ROW_NUMBER() OVER (ORDER BY PartID)-1) % 10) AS Col
And then I used a matrix with row and col as the row group and column group, respectively. You would of course replace 10 with 2. Since you have two columns, you'd actually need a second, static column group.
This method will sort left-to-right, not top down. If you wanted top-down sorting, you'd have mess with the fields a little, but you should be able to get there.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply