So this has been bugging me for quite some time now. I know it's faster to create report using the wizard, however I also thinks it's a very good idea to know how to create report using the report designer. Also, if having to change or alter an existing report then the wizard won't be able to help.
Specifically, I think grouping is a bit more complicated in SSRS than it really should be. For example, when I try to create a report using the desiger I get blocked rows inside my grouped columns and I am unable to split them. This just seems a bit dumb to me. Also adding a detail row to a group is overly complicated. To show my point, I have two screenshots attached, one showing a version of the report I created in the wizard and the other which I created with the designer. They are both grouped exactly the same, however I am unable to split cells in the report which I created using the designer.
The first attachment is my screen shot of the report I build using the wizard. Note the grouping is the same and I do not have any blocked cells within each grouped column, each cell is contained in it's own row. This report turns out just fine.
The second attachment is the same report but built using the designer. Note the group is the same, but also note the blocking of cells together under each grouping in the tablix. I am unable to split them and they are ugly.
Can anyone advise me as to how to get the exact same grouped design as I get from the wizard for grouped reports when using the designer?