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 |
|
chris_wood99
Yak Posting Veteran
70 Posts |
 Posted - 2006-01-12 : 07:50:19
|
| Hello,I have a finance report with a balance sheet report. In each unit there are a number of accounts, the report lists all transactions registered for each of these accounts in the Details part of a table. There is a grouping on these accounts and its gives a total via a grouping. I have a table footer which then provides the final figure per unit, basically the sum of all the accounts. My problem is that each report is generated when the user selects a parameter called name from a unitowner table, i.e. Finance. this queries a db table to find out which units are owned by User-"Finance", then produces the report. I need a Grand total for the User - "Finance" which is a sum of all the unit totals. how can i achieve this as User is not in my table, so adding another grouping is not working? |
|
|
|
|
|
Grand total for parameter