Newbie Q - Group Totals

• vegasbaby207

  SSC Rookie

  Points: 37

  More actions

  December 6, 2012 at 4:19 pm

  #271395

  Hi,

  I am new to SSRS but have a strong background with MS Access. I am trying to write some simple reports but am coming unstuck with getting totals to appear for some value columns.

  My dataset is a SQL view of some sales transactions with an Amount column. I have designed a basic report which has 2 group levels - first by Site then by AccountNumber. I am hiding the detail row. The total by AccountNumber [Sum(Amount)] is calculating correctly in the AccountNumber group footer. However the total by Site [Sum(Amount)] in the Site group footer is always displaying zero.

  Strangely, when I add another numeric field from the dataset (Month Number) to the report the group totals work perfectly, although this number is completely meaningless.

  Can anyone suggest something to look for?

  Thanks

• jag7777777

  SSC Enthusiast

  Points: 113

  More actions

  December 7, 2012 at 2:53 am

  #1566520

  I would double-check your data first - just to make sure there is a total by site. I only say this as you state when you add another column, data appears?

  ....also, this may sound silly - but it still catches me out from time to time when I can't see the wood from the trees - makes sure you have the '.value' in your expression - e.g. SUM(Fields!Amount.Value)

  Then check your group properties by clicking on the group in the grouping pane - have a look at what it is grouped by and make sure this is correct.

  You could also try explicitly stating the scope of your sum expression: SUM(Fields!Amount.Value,"GroupNameHere") - but this should not really be necessary if you have the expression in the right place as the scope is implied based on where you put it

  ....unless you have column groups and row groups (i.e. a matrix) in which case I find it is always better to be explicit about scope.

  Hope you solve it!

  jag7777777