使动态列和静态列在 SSRS 2005 的 Matrix 中很好地发挥作用
我有一份报告，其中按年份显示财务数据以及其他一些静态数据： 每次我尝试放入列组时，它都会在静态数据之上或之下：
FiscalYear
StaticData1 | StaticData2 | StaticData3 | StaticData4
或者：
StaticData1 | StaticData2 | StaticData3 | StaticData4
FiscalYear
我想要的是我获得静态数据，然后获得旁边的动态数据（可能是 1 或 20 个附加列）与下面相应的数据 我怎样才能让报告看起来像：
StaticData1 | StaticData2 | StaticData3 | StaticData4 | FiscalYear | FiscalYear+1 ...
非常感谢！
I have a report that shows financial data by year along with a few other bits of static data:
every time I try to put in a Column group, it does either above or below the static data:
FiscalYear
StaticData1 | StaticData2 | StaticData3 | StaticData4
Or:
StaticData1 | StaticData2 | StaticData3 | StaticData4
FiscalYear
What I want is that I get the static data and then the dynamic data (which may be 1 or 20 additional columns) right beside it with the corresponding data below
How do I get the report to look something like:
StaticData1 | StaticData2 | StaticData3 | StaticData4 | FiscalYear | FiscalYear+1 ...
Thanks much!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
请参阅动态分组，了解如何使您的基于报告参数的动态矩阵分组。
等一下。我认为这并不能回答你的问题。
听起来您好像在问如何使更多列出现在静态数据的右侧同一分组级别。我唯一可以建议的是修改您的记录集，为每个最终矩阵单元返回一行。这通常涉及部分逆旋转。
您有类似的内容：
Row1 Static1 Static2 Year
相反， Row1 Static1 Static2 Year
，您需要这个：
我希望这是有道理的。我没有太多时间来详细讨论。
另一件可能对您有帮助的事情是尝试将一个矩形放入矩阵细节单元之一。完成后，您可以根据需要将任意数量的文本框放入矩形中，并根据需要放置它们。这是获得额外值以显示的方法之一，即使您只需要一个分组级别。
See Dynamic Grouping to learn how to make your matrix groupings dynamic based on report parameters.
Wait a second. I think that doesn't answer your question.
It sounds like you're asking how to make more columns appear to the right of your static data at the same level of grouping. The only thing I can recommend is to modify your recordset to return a row for each final matrix cell. This usually involves a partial unpivot.
You have something like:
Row1 Static1 Static2 Year
Row1 Static1 Static2 Year
instead, you need this:
I hope that makes sense. I don't have a lot of time to go into much detail.
One other thing that might help you is to experiment with dropping a Rectangle into one of the matrix detail cells. Once you have that, you can drop as many text boxes into the Rectangle as you want and position them as desired. This is one of the ways to get extra values to show even though you only want one grouping level.