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 |
|
bubberz
Constraint Violating Yak Guru
289 Posts |
 Posted - 2007-01-29 : 09:13:08
|
| I can perform this running total easily w/ Cyrstal reports via the "Running Total" window where:1. I want a certain expression, here would be the sum of a money column2. I want it to total on this certain grouping3. I want it to reset on this certain groupingSo, let's say I have three groupings centering around time zones for the United States:1. Inner most group is per a state's county2. 2nd most is per actual state3. Outter most is per state regions like P.S.T, M.S.T, etc. time zones. If my detail section has multiple rows b/c of my joins then the totals are duplicated. How can I do a running total like crystal and have it "reset" on the 2nd and 3rd groupings and only do the actual "totalling" based on a criterion?Thanks! |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-01-29 : 09:35:34
|
| (Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78235) |
 |
|
|
|
|
|
Running Total help......like Cyrstal XI