How to get access SUM for each element within a Group separately in SSRS??

  • 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??

  • Can you just refer to the textbox's value property? Something like:

    =ReportItems!txtName.Value

    HTH,

    Rob

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply