开发者

a SSRS 2008 problem: How to sum with a condition

开发者 https://www.devze.com 2023-03-22 15:29 出处:网络
I have a SSRS report in which there is two column Current_Product and TempAnnSaving. Current_product has value current product and their match. that means each current product have a match row or it m

I have a SSRS report in which there is two column Current_Product and TempAnnSaving. Current_product has value current product and their match. that means each current product have a match row or it may be more than one row. Eac开发者_StackOverflow社区h match row has a TempAnnSaving value in TempAnnSaving column. Now at the end of the report I have to show the total sum of TempannSaving, but there is a condition for sum--I have to sum only first match of each current product.

0

精彩评论

暂无评论...
验证码 换一张
取 消