October 1, 2013 at 7:21 pm
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?
October 2, 2013 at 8:16 am
When you create a report in the designer and add a group, it creates a column on the left that merges all the rows together.
Delete that column. It won't change the grouping. Then insert a column to the left of ACTDESCR (right click on the column heading, choose Insert Column, Left).
The light blue line (2nd from the top) is the Group Header row. Put the field in that row.
October 3, 2013 at 8:15 am
just be sure to choose the option to delete the column only, which annoyingly is not the default.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply