报告排序无效 [英] Report Sorting isn't working

问题描述

我有一个简单的报告，它有两个控制源（查询），每个查询都有不同的排序顺序。我正在使用db.querydef来更改查询的排序选项。当我运行报告时没有进行排序，我查看查询并更改为正确的排序seq，如果我只是运行查询，一切看起来都不错。我已经检查了排序和分组，并且没有任何内容，我也检查了按开启顺序，它被设置为是。该报告根本没有排序seq，所以它就像它没有读取查询。任何帮助将不胜感激我不知所措。

谢谢

I have a simple report that has two control sources (queries) each query has a different sort sequence. I''m using the db.querydef to change the query''s sort option. When I run the report no sorting happens, I look at the query and it changes to the correct sort seq and if I just run the query everything looks good. I''ve checked into the sorting and Grouping and there is nothing there, I''ve also check the Order by On and it is set to Yes. The report has no sort seq at all so it''s like it''s not reading the query. Any help would be appreciated I''m at a loss.
Thanks

推荐答案

@CD Tom


在报告本身上设置排序和分组选项，您应该没问题。

@CD Tom
Set the Sorting and Grouping Options on the Report itself and you should be fine.

报告总是在排序和排序中管理自己的排序。分组区域。按照ADezii的说法去那里，一切都应该没问题。

Reports always manage their own sorting in the Sorting & Grouping area. Go there as ADezii says, and all should be ok.

如果我设置排序&分组到其中一个序列如何将其更改为另一个序列，查询仍然不能只使用Sort&分组确实。

If I set the Sorting & Grouping to one of the sequences how do I change it to the other sequence the queries still don''t work only the Sort & Grouping does.

这篇关于报告排序无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！