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-25 : 15:18:29
|
| I posted this information in a previous post, but I wanted to phrase my problem somewhat differently. The problem is that I can't find a way in RS to add group totals. I have 2 groups--group 1 is table1_group1_pcode, group 2 is group2_account. The pcode is a segment of the accountnumber. I need to add the amounts for the accounts that have the same pcode, and then get the total for the pcode. As you can see below, the pcode total comes to ($60,000) instead of 0. This is the expression I use in the pcode group footer.=sum(Fields!AcctTran_1_Amount.Value)+ Fields!calc_beginBal.ValueIf there is only one beginning balance for an account in the pcode group, this works. But if there is more than one beginning balance, as below, Reporting Services just takes the first beginning balance. Summing the beginning balances doesn't work. I've tried a running total with the group as scope, but I get an error message.There doesn't seem to be a way in Reporting Services to add the totals for the accounts to get the total for the pcode. But this seems impossible to me. I'm thinking there must be a way. Can anyone help?Thanks,Sue 1111 4-999-1111-2345 Account Beginning Balance ($60,000.00) 7/1/2008 Close Financial Aid Balances $60,000.00 Account Ending Balance $0.00 4-999-1111-6789 Account Beginning Balance 60,000.00 7/1/2008 Close Financial Aid Balances ($60,000.00) Account Ending Balance $0.00 1111 Pcode Total ($60,000.00) |
|
|
|
|
|
|
|
Adding group totals in RS 2005