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  Running Balance

Author  Topic  nate4088 Starting Member 1 Post Posted - 2010-09-08 : 13:30:42 Hi! I am creating a report in Showcase Report Writer and am stumped. I have a field that has a declining balance each pay perdiod depending on the deduction amount and per employee a total of 39 deductions in all ( 18 months). The original amount is not saved in any location. There has to be a way I can calculated the balance at any given time by using the deduction amount and count how many pay periods have been used...right? any suggestions or where to start would be much appreciated!! Nate