Here's a Friday question for any SSRS gurus out there. I've got a data set with some fields that I'd like to group - but, instead of moving them out to the right, I'd like to get them to show up under the grouping. Here's an example:
dataset:
col1, col2, col3a, col4b
col1, col2, col3b, col4b
col1, col2, col3c, col4c
I've got no problem getting a grouping like this to work:
col1, col2, col3a, col4a
col3b, col4b
col3c, col4c
col1a, col2a, col3a, col4a
(etc...) Basic grouping in a table, right?
In other words, parent group on the left, child group broken out on the right. but I've got a lot of data I'd like to put into my parent group, so I'd really like my child group to show up underneath the parent group instead of on the side of it.
col1, col2, col3, col4, col5, col6, col7
col8a, col9a, col10a
col8b, col9b col10b
col1b (etc... next grouping here.)
...And really, I'd like to break out of the table structure a little more for my parent group - putting columns in a more free form style than table style, but I still need that child group to show up below.
So should I still be starting with a table? Or is there a different way to lay out my data?
I hope this makes sense. Sorry for the rambling... Any ideas about where to start would be much appreciated.
thanks!
Brian