Hello, In our project we are experiencing a small problem. We want to create a table and we want the hierarchy groups to expand downwards. So we'd have say category with a total on the first row, a subcategory and total on the second row and the product details on the third row. Now when we add a parent or a child group to another group, the report designer/report builder(2008 non r2 versions) creates a new column either left or right and starts the group there, it adds the Bracket ( [ ) to that new column. This is not what we want. We want the 2nd and 3rd hierarchy on a new row but in the same column as the parent group. Now when we tried to make a report with the wizard and chose the stepped layout, the grouping all started on the same column, the headers started on a new column but that was easily changed by just adding the value to the first column instead of the second/third etc. We ended up taking that table the wizard created and working with that one. But we can not seem to do it manually. For some more visual examples: What we get: [Category[Subcategory[Product. what we want: [Category [[Subcategory [[[Product Where the category group groups over the other 2 rows, subcategory over the product group. We hope someone can tell us if we can do this manually or not, and if so, how we can achieve that. Note: We don't want adjacent groups, we do want the hierarchy.

Hello, You can do it manually and it is very simple. Just copy the values for Subcategory and Product on their table rows from its column to the first column (under the Category) and delete the second and third columns... Miloslav Peterka

http://www.mssqltips.com/tip.asp?tip=1939 r u looking for stuff some thing like thisPraxy

Here are two pictures to explain it further. This one was made by the wizard: http://img228.imageshack.us/i/desired.jpg/ This one was made by me. http://img97.imageshack.us/i/whatweget.jpg/ The difference between the 2 is the column where the group starts. Look at the brackets. On the wizard one they all start at the same first column. On the one I made they all start on new columns. In the 2nd one i can't split the cells under the groups because the other groups start at a new column. So far all I found about this were 2 other people asking the same question, and no answers anywhere. Hope this clarifies exactly what i want to achieve.

We finally got it to work. I'm not sure if this is what Miloslav also meant. It seems similar enough. I deleted the first 3 columns and the row groups started on the first column they could find after the detail lines, the double dashed line. After that I added 3 new columns and the group starting point stayed on the first column. This really doesn't seem like a good way to achieve this, we use report models to let clients edit our reports or make their own ones, but it won't be easy explaining this to them. If anyone knows a better way please share it. In any case, thanks for the replies.

Hi there: I think this is what you are looking for. http://msdn.microsoft.com/en-us/library/cc281376(v=sql.100).aspx CheersDavid Chen