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?
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 MVP http://visakhm.blogspot.com/
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 MVP http://visakhm.blogspot.com/
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 MVP http://visakhm.blogspot.com/
why do you nead to access it via reportitems? why can you fetch values from dataset?
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
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.
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 MVP http://visakhm.blogspot.com/
why do you nead to access it via reportitems? why can you fetch values from dataset?
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Sum Report Items
Posted - 12/19/2012 : 06:19:12
