Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Question About Creating Grouped Reports Outside of the Wizard


Question About Creating Grouped Reports Outside of the Wizard

Author
Message
Polymorphist
Polymorphist
Valued Member
Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)Valued Member (57 reputation)

Group: General Forum Members
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?
Attachments
WizardGrouping.JPG (22 views, 16.00 KB)
GroupReportDesigner.JPG (19 views, 15.00 KB)
sql Sarah
sql Sarah
SSC-Enthusiastic
SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)SSC-Enthusiastic (109 reputation)

Group: General Forum Members
Points: 109 Visits: 589
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.
Steven.Howes
Steven.Howes
SSChasing Mays
SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)SSChasing Mays (652 reputation)

Group: General Forum Members
Points: 652 Visits: 2327
just be sure to choose the option to delete the column only, which annoyingly is not the default.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search