all groups > sql server reporting services > october 2006 >
You're in the

sql server reporting services

group:

display 'groups' next to each other??



display 'groups' next to each other?? tlyczko
10/24/2006 8:57:18 AM
sql server reporting services: I work for a non-profit agency which is slooowly computerizing itself.

We recently acquired SS 2005 and I am learning RS 2005.

My question: How can I create a report format such that the 'groups'
are adjacent to each other??

This is not the same as multi-column report, which looks like
newspapers.

I want:

Group 1
Category 1 Category 2 Category 3
Item 1 Item 22 Item 31
Item 2 Item 35 Item 41
Item 3 Item 45 Item 51
Item 4 Item 55 Item 61


Group 2
Category 1 Category 2 Category 3
Item 10 Item 322 Item 310
Item 20 Item 335 Item 410
Item 30 Item 345 Item 510
Item 40 Item 355 Item 610

Or is this not possible in RS2005 and I must use a regular HTML page
sort of thing???

Thank you, Tom
Re: display 'groups' next to each other?? weelin
10/24/2006 9:24:25 AM
This looks like two tables on one report, with different groups on,
using the same Dataset rather than one table with fancy grouping.




[quoted text, click to view]
Re: display 'groups' next to each other?? tlyczko
10/24/2006 9:55:42 AM
I don't think so.
Tables always display data vertically, top to bottom.
I want across for one type of data (category)
then lists across (members of each category)
I'll see if I can do that though
Thanks, Tom

[quoted text, click to view]
Re: display 'groups' next to each other?? tlyczko
10/24/2006 2:27:38 PM
Still trying this out, but it is not displaying the items under the
categories properly, they are either 'stepped,' or there are gaps in
the list rows, etc. etc., and the matrix doesn't seem to have a way of
'wrapping' the columns around, I don't want one giant
spreadsheet-looking thing, I would like a four-column sort of thing.

Thank you, Tom

P.S. I'm beginning to think it's impossible.

[quoted text, click to view]
Re: display 'groups' next to each other?? Kaisa M. Lindahl Lervik
10/24/2006 10:24:29 PM
Have you looked at the Matrix control yet, compared to Table? To me it looks
like you should use a matrix, with coloum groups set to Category. You might
have to tweak your data set a bit, to get both column groups and row groups,
but matrix is still the best way to go.

Kaisa M. Lindahl Lervik

[quoted text, click to view]

AddThis Social Bookmark Button