Grouping results in a Report - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Grouping results in a Report

Author

Topic

rohcky
Starting Member

38 Posts

Posted - 2005-06-15 : 14:20:54

I'm trying to create a Report that groups the data by a specific id. For instance, lets say my table has the following data:

<name> <data type> <data value>
----------------------------------
d1 a 123
d1 b 345
e1 c 234
e1 d 567
e1 e 346

Is it possible to have the Report print out as:

<name> <data type> <data value>
----------------------------------
d1 a 123
... b 345
e1 c 234
... d 567
... e 346

(The periods are there to preserve the spacing. It should be blank in the name where there are periods)

I want the data to be grouped without showing the name over and over again.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-06-15 : 15:34:44

Yes. Create a grouping row. Select your name column to be the grouping item. The other columns will be in the detail rows. Check out the Sample Reports if you need to see an example.

Tara

rohcky
Starting Member

38 Posts

Posted - 2005-06-15 : 15:46:03

Thank's for the help!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources