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 |
|
simpleton
Starting Member
25 Posts |
 Posted - 2010-03-04 : 10:37:37
|
| I have a report that calculates correctly, but I can’t get the rows to total. Visual Studio complains about Aggregate Functions.I have no idea how to fix this, and get my totals.Here are my crazy formulas I’m using to get the column data.Column C = B/SumOfBColumn E = C*DColumn H = G/F*0.012Column I = H*CAny help would be most appreciated!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-04 : 11:11:33
|
| why you cant total? all except column C has no aggregate functions so it should work fine. for C you might have to use hidden field with sum(b) and then use reportItems!textbox.value instead of direct SUM------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
simpleton
Starting Member
25 Posts |
Posted - 2010-03-05 : 14:43:29
|
| Seems like no matter how I ran Visual Studio, it would keep giving me Aggregate errors.I ended up solving the problem by doing all the calculations in the SQL backend. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-06 : 02:18:11
|
| whats version of visual studio you were using?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
simpleton
Starting Member
25 Posts |
Posted - 2010-03-08 : 07:19:31
|
| Visual Studio 2005 Professional |
|
|
|
|
|
|
Need column Totals but VS complains Aggregate Func