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 |
|
huynhtl
Posting Yak Master
107 Posts |
 Posted - 2009-04-09 : 18:34:46
|
| Hi,I have a table is a drilldown and within that table, i have four groups and one table detail, everything works fine except in the table details. In the table detail, i would like all same doctors to show up one time and add all of dollar together. I did a group by doctors, and it shows doctors once, but the dollar was not add up.here's an example of what i don't want: if you notice, total is $5,220.00, and doctors show multiple times with individual dollars.IMPACTION - UNUSUAL DIFFICULTIES $5,220.00 $1980 J CLIFFORD LASNETSKE DDS $1620 J CLIFFORD LASNETSKE DDS $720 J CLIFFORD LASNETSKE DDS $540 ORAL SURGERY ASSOCIATES INC $360 ORAL SURGERY ASSOCIATES INC example of what i want:IMPACTION - UNUSUAL DIFFICULTIES $5,220.00 $4320 J CLIFFORD LASNETSKE DDS $900 ORAL SURGERY ASSOCIATES INC Please help!!!!!!!!!Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-12 : 13:56:26
|
| use SUM(Fields!dollar.value) after applying grouping on doctor. |
 |
|
|
huynhtl
Posting Yak Master
107 Posts |
Posted - 2009-04-15 : 13:30:44
|
| thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-15 : 13:40:52
|
| welcome |
|
|
|
|
|
|
Having problem with table details