指定报告外部报告的排序顺序 [英] Specify sorting sequence for report outside report

问题描述

我的用户想要一个特殊的报告工具。目前有固定数量的报告，每个报告都有自己的数据字段和自定义排序顺序。用户选择报告，这将确定选择标准，要包括的字段以及报告的
排序顺序。

My users want an ah-hoc reporting facility. Currently there are a fixed number of reports, each of which has its own data fields and custom sort sequence. The user selects the report and this determines the selection criteria, fields to be included and the sort sequence of the report.

现在我需要完全自定义。他们将不再选择报告，他们将指定选择标准和排序顺序。我将始终包含所有数据字段。

Now I need to make this completely customizable. They will no longer select a report, they will specify the selection criteria and the sort sequence. I will always include all data fields.

我的问题是如何为报表本身以外的报表指定排序顺序（可以是单级或多级排序），还是这样做？要传递给报告，然后在报告的公开活动中设置？

My question is how do I specify the sorting sequence (can be single or multi level sorting) for a report outside the report itself, or does this have to be passed to the report and then set in the report's open event?

谢谢。

推荐答案

由于报告使用自己的分拣系统，您必须先打开报告，然后从外部应用排序顺序。例如：

Since reports use their own sorting system, you'll have to open the report first and then apply the sorting order from the outside. For example:

DoCmd.OpenReport" ReportName"，acViewPreview

DoCmd.OpenReport "ReportName", acViewPreview

Reports！ReportName.OrderBy" FieldName"

Reports!ReportName.OrderBy "FieldName"

报告！ReportName.OrderByOn = True

Reports!ReportName.OrderByOn = True

希望它有所帮助......

Hope it helps...

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