本文介绍了使用列组在ssrs中创建矩阵报告的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
I have a table
<pre lang="C#">
CardNo HOFM Members SchemeName CommodityName Qty Rates
1 A 5.0 AAY Wheat 0.20000 150.00
1 A 5.0 AAY Rice 0.75000 250.00
2 B 6.0 AAY Wheat 0.20000 150.00
2 B 6.0 AAY Rice 0.90000 250.00
I want to generate matrix report like below
CardNo HOFM Members Commodity in KG Fund(Rs)
Wheat Rice Total Wheat Rice Total
Qty1 Qty2 Qty1+Qty2 Qty1*R Qty2*R Qty1*R+Qty2*R
Where Qty1=wheat Qty, Qty2=Rice Qty,R=Rates
I have tried grouping column wise
我尝试了什么：
我尝试过分组列
What I have tried:
I have tried grouping column wise
推荐答案
这篇关于使用列组在ssrs中创建矩阵报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！