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 |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2012-12-19 : 06:19:12
|
| Hi,I know SSRS 2008 R2 or any other version of SSRS doesnt allow it, but there must be a function or custom code I can write to allow me to sum all the report items.value in a group.Has anyone come across this before and have code or explain how to write the code, handy?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-12-19 : 08:09:59
|
| you mean horizontally aggregating values? as by default you could simply use aggregate function with scope specified as your group to aggregate data vertically------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2012-12-19 : 08:19:46
|
Well I did a sum(reportitems!box1.value) and ssrs doesnt like it. Columns Rows Value (Customer Forumla here) Total Sum(Box above)quote:
Originally posted by visakh16
you mean horizontally aggregating values? as by default you could simply use aggregate function with scope specified as your group to aggregate data vertically------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-12-19 : 08:57:52
|
quote:
Originally posted by cipriani1984
Well I did a sum(reportitems!box1.value) and ssrs doesnt like it. Columns Rows Value (Customer Forumla here) Total Sum(Box above)quote:
Originally posted by visakh16
you mean horizontally aggregating values? as by default you could simply use aggregate function with scope specified as your group to aggregate data vertically------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
why do you nead to access it via reportitems? why can you fetch values from dataset?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Matengele
Starting Member
4 Posts |
Posted - 2013-01-01 : 11:22:33
|
| Hi,under row groups, choose either the details group or an immediate child group of the group whose items you want to sum , click the drop down on the right of that group and select add total after. |
|
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2013-01-08 : 05:08:54
|
Because its a Analysis services dataset.quote:
Originally posted by visakh16
quote:
Originally posted by cipriani1984
Well I did a sum(reportitems!box1.value) and ssrs doesnt like it. Columns Rows Value (Customer Forumla here) Total Sum(Box above)quote:
Originally posted by visakh16
you mean horizontally aggregating values? as by default you could simply use aggregate function with scope specified as your group to aggregate data vertically------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
why do you nead to access it via reportitems? why can you fetch values from dataset?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
|
|
|
Sum Report Items