How to show grouped items in one row.

Question

How to show grouped items in one row.

4EverandEver

Default port

Points: 1485
More actions
July 19, 2010 at 9:32 am

#237798

Hi all I have a the following report that shows systems in each server, I added a groud (Serverid) and in the details shows all systems in each server and it appears like this.
Servername Systems
SERVER01
System A
System B
SERVER02
System C
System D
However the clilent requires everything in on one row like this:
SERVER01 System A - System B
SERVER02 System C - System D
how can I achieve this in an SSRS report?
many thanx.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Abs-225476 Hall of Fame Points: 3483 More actions · Answer 1

Hi, you can use a matrix object which will allow you to flip the data so you have servderid as the first column followed by a number dynamic columns for system details

column 1 column2 column3 column4 column5 etc . . . .

serverid systemA systemB

serverid systemC systemE systemF

4EverandEver Default port Points: 1485 More actions · Answer 2

Hi,

Thanks for the response,

Using the Matrix control i get Rows, Columns and Data. I tried putting the serverId on the columns box but it only shows the systems for Server01 and not all the data. Please tell me what to put in each box; Rows, columns and data, i have tried swapping values for these to no avail.

thanks.

4EverandEver Default port Points: 1485 More actions · Answer 3

I finally got this right using the Matrix control thanks, the one issue i'm having is when I'm exporting it to excel, it only shows one row, what do i need to do to have the matrix rendered correctly in Excel?