grouping and sort property in reports

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

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

grouping and sort property in reports

Author

Topic

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2007-10-23 : 04:45:55

Hi,

I am facing some problem while grouping the fields..
I try to form one report where I get group by States then by city and then total count of states
like

State: A
city:1
No of ppls:
no of houses:
city:2
No of ppls:
no of houses:
city:3
No of ppls:
no of houses:
Total No of ppls in State A:
State: B
city:4
No of ppls:
no of houses:
city:5
No of ppls:
no of houses:
city:6
No of ppls:
no of houses:
Total No of ppls in State B:

Please help me out

T.I.A

tm
Posting Yak Master

160 Posts

Posted - 2007-10-23 : 09:05:53

Have you read books on line .. Grouping [Reporting Services] >> Working with Table Data Regions.
There are samples on how to do this.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources