Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Question About Creating Grouped Reports Outside of the Wizard Expand / Collapse
Posted Tuesday, October 1, 2013 7:21 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, August 29, 2016 5:57 PM
Points: 57, Visits: 265
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?

  Post Attachments 
WizardGrouping.JPG (21 views, 16.96 KB)
GroupReportDesigner.JPG (19 views, 15.15 KB)
Post #1500637
Posted Wednesday, October 2, 2013 8:16 AM


Group: General Forum Members
Last Login: Friday, November 18, 2016 8:05 AM
Points: 103, Visits: 582
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.
Post #1500790
Posted Thursday, October 3, 2013 8:15 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, December 2, 2016 8:37 AM
Points: 646, Visits: 2,324
just be sure to choose the option to delete the column only, which annoyingly is not the default.
Post #1501211
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse