有没有办法在 Report Builder 3.0 中指定查询的排序，而不是使用“编辑为文本”？
在Report Builder 3.0 中，您可以打开报表或查询。当您打开查询时，您将进入全屏可视化查询设计器。
我不知道如何表明我想在此设计器中对列进行排序。有一个“编辑为文本”模式。当我进入那里时，它会显示 SQL 语句。我可以在末尾添加一个 ORDER BY 子句，当我运行查询时，这可以正常工作。
但是，一旦在“编辑为文本”模式下编辑查询，就无法切换回可视设计器。当您尝试时，它会告诉您，您将丢失对已更改查询所做的更改，或丢失对已保存的“编辑为文本”查询的整个 SQL 语句。果然，你做到了！
我是否错过了什么，或者确实没有办法在 Report Builder 3.0 可视化设计器中指示查询的排序？
In Report Builder 3.0, you can open a report, or a query. When you open up a query, you're in a full-screen visual query designer.
I cannot figure out how to indicate that I want to sort columns in this designer. There is an "Edit as Text" mode. When I go in there, it shows the SQL statement. I can add an ORDER BY clause at the end, and when I run the query, this works fine.
However, once you edit a query in "Edit as Text" mode, you cannot switch back to the visual designer. When you try, it tells you that you'll lose the changes you made to a changed query, or the whole SQL statement to a saved "Edit as Text" query. And sure enough, you do!
Did I miss something, or is there really no way to indicate a sort for a query in the Report Builder 3.0 visual designer?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我也找不到在查询设计器中执行此操作的方法。但是，将数据集附加到报表中的表对象后，您可以打开表属性并指定其排序顺序。例如，插入一个表并将数据集与该表关联。在报表的设计视图中，右键单击新创建的 Tablix 对象。单击左侧窗格中的“排序”，然后添加要排序的字段。
I can't find a way to do this in the Query Designer either. However, once you you attach a dataset to a table object in the report, you can open up the table properties and specify the sort order on it. For example, insert a table and associate your dataset with the table. In the design view of the report, right click on your newly created Tablix object. Click on "Sorting" in the left pane and add the fields on which you wish to sort.