Can i print the Difference of two Quantities in my SSRS Report?
Hii,
I have a Report, see image below.
As you can see in the first Row,the first Grn number has two entries for different dates. Can i print the Total Value as '0' (10-10) for the first GrnNumber?
October 5th, 2012 3:42pm
It is not possible in the SSRS but you can do it when you fetch the data from database. You can use Over() and "Partition by" to achieve this.
The query will look like
select Stock, Gru,Sum(Qty) over(partition by Stock, Gru) as Total from Table1
This will help you i guess
Bunch of thanks ~ Deva ~ mark it as answer if it answered your question :)
Free Windows Admin Tool Kit Click here and download it now
October 5th, 2012 4:17pm
It is not possible in the SSRS but you can do it when you fetch the data from database. You can use Over() and "Partition by" to achieve this.
The query will look like
select Stock, Gru,Sum(Qty) over(partition by Stock, Gru) as Total from Table1
This will help you i guess
Bunch of thanks ~ Deva ~ mark it as answer if it answered your question :)
October 5th, 2012 4:17pm