你如何定义自己的分组方法？ [英] How do you define your own grouping method?

问题描述

大家好，


我有一个包含不同分组级别的报告，我只能选择升序或降序来对报告中的当前状态字段进行分组。


问题是我希望当前状态字段按特定顺序分组，不符合升序或降序。例如，我想要以下订单：

1.等待详情

2.正在进行中

3.已关闭


如何将报告按此顺序分组？我希望有人可以帮忙。

Hello everyone,

I have a report with different grouping levels, and I can only select ascending or descending to group the ''Current Status'' field in my report.

The problem is that I want the ''Current Status'' field to be grouped in a particular order which does not fit into ascending or descending. For example, I want the following order:
1. Awaiting details
2. In progress
3. Closed

How do I get the report to be group in this order? I hope someone can please help.

推荐答案

大家好，

我有一个包含不同分组级别的报告，我只能选择升序或降序来对报告中的当前状态字段进行分组。


问题是我希望当前状态字段按特定顺序分组，不符合升序或降序。例如，我想要以下订单：

1.等待详情

2.正在进行中

3.已关闭


如何将报告按此顺序分组？我希望有人能请求帮助。

Hello everyone,

I have a report with different grouping levels, and I can only select ascending or descending to group the ''Current Status'' field in my report.

The problem is that I want the ''Current Status'' field to be grouped in a particular order which does not fit into ascending or descending. For example, I want the following order:
1. Awaiting details
2. In progress
3. Closed

How do I get the report to be group in this order? I hope someone can please help.

如果您更改已关闭的状态说明，则可以轻松完成。某些人喜欢项目已结束因此，关闭状态将按字母排序排序。然后你需要做的就是：

1.使用排序分组工具，输入status。在字段区域的第一行上升。

2.在组属性部分中，选择Group on：prefix characters。

3.对于组间隔：1

You can do it easily, if you change the status description for "Closed" to someting like "Project Closed" so that the closed status will sort last in an alpha sort. Then all you have to do is this:
1. Using the sorting grouping tool, enter "status" ascending on the first row of the field area.
2. In the group properties section, select Group on: prefix characters.
3. For group interval: 1

对不起，这对我不起作用，因为我不能改变''关闭''到''项目关闭''。我希望它会那么简单！


不幸的是，它必须说''已关闭''。有没有其他方法可以这样做？

Sorry, that will not work for me because I can''t change ''Closed'' to ''Project Closed''. I wish it would be that easy!

Unfortunately, it has to say ''Closed''. Is there any other way of doing this please?

抱歉，这对我不起作用，因为我无法改变''关闭''到''项目已关闭''。我希望它会那么简单！


不幸的是，它必须说''已关闭''。有没有其他方法可以这样做？

Sorry, that will not work for me because I can''t change ''Closed'' to ''Project Closed''. I wish it would be that easy!

Unfortunately, it has to say ''Closed''. Is there any other way of doing this please?

是的。

1.在当前状态的文本框旁边放置一个文本框。将其命名为txtSort。

2.在txtSort的控制源中使用以下表达式：

= IIf（[Current Status] =" Awaiting details"，1，IIf （[Current Status] =" In Progress"，2,3））

3.将txtSort作为排序分组工具中的第一项，

Yes there is.
1. Place a textbox next to the textbox for Current Status. Name it txtSort.
2. Use the following expression in the control source for txtSort:
=IIf([Current Status] = "Awaiting details", 1, IIf([Current Status] = "In Progress", 2, 3))
3.Place txtSort as the first item in the sorting grouping tool,

这篇关于你如何定义自己的分组方法？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！