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.
| Author |
Topic |
|
duanecwilson
Constraint Violating Yak Guru
273 Posts |
 Posted - 2009-08-19 : 09:46:44
|
| I am trying to group on team, and get a count for each team, but there are different patient numbers for each team. I am evidently getting a count of each patient and team, not just team. I want just one count for each team, not for team and patient. So the way my report looks right now is many lines with the same team, but different counts (so each line is obviously referring to different data), but I just want to aggregate all the counts into one for each team. What am I missing?Duane |
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-08-19 : 16:27:11
|
| so you want just the team and no patient in the report? can you paste a screenshot of the report layout? |
 |
|
|
|
|
|
How to do grouping properly