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 Calculate Row-wise Data Totals into a column in SSRS 2008 Matrix Report ? Expand / Collapse
Author
Message
Posted Tuesday, July 23, 2013 1:25 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, October 28, 2013 2:48 AM
Points: 64, Visits: 367
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.


  Post Attachments 
Sample Data.JPG (13 views, 11.03 KB)
Post #1476381
Posted Sunday, July 28, 2013 7:23 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 28, 2014 1:02 PM
Points: 150, Visits: 445
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.
Post #1478426
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse