SSRS 2008 - 根据行号获取数据
我需要创建一个包含仪表集合的报告。进入报告的数据结构如下：
Client Specialty TrendsPercent
ABC Hematology 33.2
ABC Urgent Care 30
DEF Psychiatry 80
DEF Pulmonary 59
DEF Neurology 12
每个客户的行数以及列出的专业都是可变的。我一直在尝试做的是创建一个 5x5 的仪表网格。原始数据中的每一行都是一个仪表。所以：
Row1Gauge | Row2Gauge | Row3Gauge | Row4Gauge | Row5Gauge
Row6Gauge | Row7Gauge | Row8Gauge | Row9Gauge | Row10Gauge
等等。
我遇到的问题是如何仅根据行号引用某一特定行的数据？仪表太多，无法在 Tablix 对象中只包含一列，我需要仪表至少 5 宽。我尝试过根据 RowNumber 过滤 tablix，但 SSRS 不允许这样做。关于我如何解决这个问题有什么想法吗？
I need to create a report with a collection of gauges. The data coming into the report is structured like:
Client Specialty TrendsPercent
ABC Hematology 33.2
ABC Urgent Care 30
DEF Psychiatry 80
DEF Pulmonary 59
DEF Neurology 12
The number of rows for each client, as well as the specialties listed, is variable. What I've been trying to do is create a 5x5 grid of gauges. Each row in the original data will be a gauge. So:
Row1Gauge | Row2Gauge | Row3Gauge | Row4Gauge | Row5Gauge
Row6Gauge | Row7Gauge | Row8Gauge | Row9Gauge | Row10Gauge
etc.
The problem I've been running into is how do I reference one specific row's data based solely on the row number? There are too many gauges to just have one column in a tablix object, I need to have the gauges 5 wide at least. I've tried filtering a tablix based on the RowNumber but SSRS doesn't allow that. Any ideas on how I could go about this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我能够找到解决这个问题的方法。虽然您无法根据行号过滤 Tablix，但您可以根据行号设置可见性。因此，我有 5 个并排的 tablix，我将第一个 tablix 的可见性设置为显示第 1、6、11、16、21 行。它旁边的 tablix 仅显示第 2、7、12、17 行、22 等。我不知道在 sharepoint 站点上使用该报告时这将如何影响性能，但我知道没有其他方法可以解决此问题。
I was able to figure out a work around for this. While you can't filter a tablix based on row number you CAN set visibility based on it. So, I have 5 tablixes side by side and I'm setting the visibility on the first one to show for rows 1, 6, 11, 16, 21. The tablix next to it is only showing rows 2, 7, 12, 17, 22, etc. I don't know how this is going to affect the performance when the report is used on the sharepoint site, but I know of no other way of going about this.