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 |
|
insanepaul
Posting Yak Master
178 Posts |
 Posted - 2010-11-16 : 04:52:54
|
| In my Total column in the report layout I have grouped rows. Each line in the group has the same total. I just want to show the total once for each group therefore I use:=First(Fields!Total.Value)At the end of the report I want to add up all the Totals for a grand total. If I use: =Sum(Fields!Total.Value, "dsInvoiceDetails")then I get the sum of the total for each line within each group.I can't use: =Sum(First(Fields!Total.Value, "dsInvoiceDetails"))as I get error message regarding aggregates which I've googled and not found the answer.How do I sum the total for the first line of each group? |
|
|
insanepaul
Posting Yak Master
178 Posts |
Posted - 2010-11-16 : 06:09:37
|
| Does this make any sense? Ijust want to add the first line of each group to a total field |
 |
|
|
rexyrexin
Starting Member
19 Posts |
Posted - 2010-12-20 : 09:06:04
|
| Add a column in the end. In the row of group header go to last column and write in expression.=Sum(Fieldname) |
|
|
|
|
|
|
Adding a Grand Total to the report