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 |
|
sue1127
Starting Member
23 Posts |
 Posted - 2009-03-02 : 14:00:01
|
| I am using SSRS 2005, and I need to sum the beginning balance of each account with the transaction details. The beginning balance is repeated for each of transaction detail data. I was able to display just the first instance and place it in the group row(grouping by the account). But SSRS won't let me sum just the First with all the transaction detail amounts. It sums a beginning balance amount for each transaction detail line. I can't find a way to include only one beginning balance for each account.Can anyone please help?Thanks,Sue |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-03 : 12:43:03
|
| try=First(Fields!BeginningBalance.value,"your group name here") |
 |
|
|
|
|
|
how to sum first in a group with details