SSRS 图表中的可选系列？
是否可以将图表中的一系列设为可选（即仅在用户单击复选框时呈现，以防相应的查询需要一段时间并且可能不需要）？
或者是否有任何替代解决方案，用户可以逐步选择他们想要查看的数据系列/图表？
is it possible to make a series in a chart optional (i.e. only rendered when the user clicks a checkbox, in case the corresponding query takes a while and may not be required)?
Or are there any alternative solutions where users can incrementally select the data series/charts they would like to see?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我在 SSRS 2008 中遇到了类似的问题，我试图根据系列值的值隐藏一个系列。 我尝试设置该系列的可见性，但没有任何效果。 然后我尝试将系列隐藏在图例上，希望它也能将其隐藏在图表上，但事实并非如此。 最后，我将系列的值设置为表达式
=iif(fieldvalue=0,"",fieldvalue)，因此如果系列的值为 0，则不会返回任何值，它还隐藏了传说中的系列。 这有点晚了，但希望对某人有所帮助。I was having a similar problem in SSRS 2008, I was trying to hide a series based on the value of the series value. I tried to set the visibility on the series, but that did nothing. Then I tried hiding the series on legend hoping it would also hide it on the chart, it did not. Finally, I set the value of the series to an expression,
=iif(fieldvalue=0,"",fieldvalue), so it would return no value for the series if it had a value of 0, it also hides the series in the legend. This is a little late, but hopefully it helps someone.这可以通过参数来实现。
您可以设置参数来决定运行时在报表上显示的内容。 您可以借助报表查看器控件旁边的一些控件以编程方式设置参数。
This can be achieved with Parameters.
You can set parameters to decide what is to be displayed on the report during runtime. You can programatically set the parameters with the help of a few controls places alongside the reportviewer control.