Post reply

How to Calculate Row-wise Data Totals into a column in SSRS 2008 Matrix Report ?

  • July 23, 2013 at 1:25 am

    #395184

    [font="Courier New"]Hi All,

    Below is sample report data, In this report I want to show Total Inventory column such that Inventory Avl till date i.e from 1st june to 3rd june for respesctive materials is to come in Total Invetory column i.e. For Item A 2 +3 + 4 = 9, Item B 1 + 5 + 5 = 11 and so on. I have tried every possible ways to achieve this (in SQL script, used SSRS expression, Although I am getting total inventory but getting wrong values) but got stucked every time. I am using sql 2008 and SSRS 2008. [/font]

  • July 28, 2013 at 7:23 pm

    #1636514

    Probably the same item is being counted under more than one date of the matrix, but when you count items across all dates, it is being counted only once.

    Without knowing the underlying data fields, it is difficult to make a specific recommendation. But my guess is that you will need to find an expression that generates a unique value for each item-plus-date combination and then count that value instead of just counting the items per se.

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

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