按参数对表进行排序 (Reporting Services 2008)
在 Reporting Services 2008 中,我想通过使用参数对表进行排序。 该表具有“MainCategory”和“SubCategory”字段。我的参数称为 SortCriterion,有两个标签:“主类别”和“子类别”。 表的排序表达式应该是
=Parameters!SortCriterion.Value
但我不知道要插入什么作为参数的值。我天真地尝试过
Fields!MainCategory.Value
,
Fields!SubCategory.Value
但没有成功。这可能吗?如何实现?
In Reporting Services 2008, I would like to sort a table by the use of a parameter.
The table has fields MainCategory and SubCategory. My parameter is called SortCriterion and has two labels, "Main Category" and "Sub Category".
The sortexpression of the table should then be
=Parameters!SortCriterion.Value
But I do not know what to insert as value for the parameters. Naively, I tried
Fields!MainCategory.Value
and
Fields!SubCategory.Value
but it doesn´t work. Is it possible and how?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
尝试将表的排序表达式设置为:
如果这没有给您想要的结果,请举例说明您要进行的排序。
Try setting the Sort Expression of the table to:
If this doesn't give you the results you want then please give an example of what sorting you are after.