报告服务矩阵顺序
我有一个报告服务报告，它以矩阵形式显示数据。
矩阵行按特定字段值的报告排序。
问题是我希望一个特定的值始终出现在矩阵的最后，即使它不会自然地在那里排序。有没有办法使用表达式来做到这一点？
谢谢。
I've got a reporting services report which display data in a matrix.
The matrix rows are ordered by the report on a specific field's value.
Trouble is I want a particular value to always appear last in the matrix even though it won't naturally be ordered there. Is there a way I can do this using an expression?
Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您可以向查询结果添加一个虚拟列来存储您最喜欢的订单值。这意味着您必须手动为记录指定一个顺序值，然后按该值对结果进行排序。
也许这对你来说是一个解决方案。
you can add a virtual column to your query result that stores your favorite order value. it means you must give a order value to your records manually then order your result by this value.
maybe this be a solution for you.
不应该太难。首先按
=if(THAT_FIELD = THE_VALUE_I_WANT, 1, 0)等表达式进行排序，该表达式对于您想要的值计算结果为 1，对于其他值计算结果为 0，因此放入您感兴趣的值最后的。然后按 THAT_FIELD 第二排序。Shouldn't be too hard. Sort first by an expression like
=if(THAT_FIELD = THE_VALUE_I_WANT, 1, 0)which will evaluate to 1 for the value you want, and 0 for anything else, therefore putting the value you're interested in last. Then sort by THAT_FIELD second.