SQL Server - list controls

Asked By dataGirl

19-Mar-10 01:51 PM

I have the 2005 version of Reportiong Services.  Is there a way to make my
list data display left to right and not top to bottom?  If I use a list
control, the data is displayed as follows:

red
green
blue

However, I would like the list to be displayed as follows:

red green blue

Is this possible?  If so, how do I do it?

21-Mar-10 05:14 AM

Doing crosstab  on the client?

22-Mar-10 11:05 AM

In SSRS 2005, instead of using a table, use a Matrix.  Drag the field
you would like (in this case color) to the columns section of the
matrix.

That should do exactly as your expecting.

Thanks,
Mike Lum

23-Mar-10 02:15 PM

I am sorry, I think I misread this.  What I would do here, is have
three lists set up side by side, with filters on each list to only
allow the proper values.  So you would have your red, green, and blue
lists side by side with filters on each for red, green, and blue only.