在 SSRS tablix 中动态重新排序列并设置列宽
我们的应用程序中有一个网格,我们需要将其呈现为将在 SSRS 中呈现的报告的一部分。用户可以在应用程序中更改此网格中列的顺序和大小。
我现在需要使打印的网格与呈现报告时的列顺序/列大小相匹配。
目前,该网格已呈现为报表上的 Tablix。我尝试使用参数/表达式来设置 TablixColumn/Width,但这似乎不起作用。
还有其他人遇到过这个要求吗?有解决办法吗?
We have a grid on our application that we need to render as part of a report that will be rendered in SSRS. The user has the ability to change the order and sizes of the columns in this grid in the application.
I now have the requirement to make the printed grid match the column order / column sizes at the time the report is rendered.
At the moment, this grid is rendered into a Tablix on the report. I have tried using a parameter / expression to set the TablixColumn/Width but this does not apear to work.
Has anyone else encountered this requirement? Any pointers to a solution?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
实际上,您可以在完成渲染过程后立即删除 rdl。 Web 服务端点中有一种用于从服务器删除报告的方法。
Actually you can delete the rdl as soon as you complete the rendering process. There is a method in webservice endpoint for deleting report from the server.
我不确定您是否找到了答案,但我们正在做类似的事情。您将阅读报表,获取 RDL 的 XML 文件,导航到包含 Tablix、TablixColumns 等的部分,然后使用 XML 类重新排序列,将报表写回报表服务器,然后呈现报表。我正在寻找更简单的替代方案,但尚未找到。如果有人有任何建议请告诉我。 :)
I am not sure if you have found your answer, but we are doing something similar. You'll read the report, get the RDL's XML file, navigate to the section where you have Tablix, TablixColumns etc., and then use XML classes to re-order columns, write the report back to Report server then render the report. I am looking for a simpler alternative, but haven't found it yet. Let me know if anyone have any suggestions. :)