Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to get access SUM for each element within a Group separately in SSRS?? Expand / Collapse
Author
Message
Posted Thursday, November 21, 2013 11:45 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, December 22, 2014 12:26 AM
Points: 73, Visits: 102
Hi,

I've have a report in SSRS where i'am grouping on a column and showing its aggregate alongside it. The report will be in a format similar to below:

State Population
abc 100
xyz 200
pqr 300

In the tablix, grouping is being done on State Column and sum of corresponding Population field is shown.

Now is there a way to access these SUM values outside the group, like i would like to access Population SUM of state abc, xyz and pqr individually. Is it possible, if so then how??
Post #1516651
Posted Friday, November 22, 2013 8:22 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 1:34 PM
Points: 1,238, Visits: 1,276
Can you just refer to the textbox's value property? Something like:

=ReportItems!txtName.Value

HTH,
Rob
Post #1516809
Posted Friday, November 22, 2013 9:02 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, December 22, 2014 12:26 AM
Points: 73, Visits: 102
I'm not sure if that will work since the text box is within a Group and there will be multiple text box on run time depending on the number of States present in the data.

Anyways i did get the solution for it at some other place. It used an expression like the one below:

sum(iif(Fields!State.Value="abc",Fields!Population.Value,0))

I have to use similar expression to get SUM values for other States.
Post #1516839
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse