本文介绍了一种在报表设计中实现按月分组的方法。具体步骤包括：1. 对日期字段进行分组；2. 在插入分组屏幕中选择按月打印；3. 设置自定义分组名称为公式形式；4. 使用特定公式定义分组名称，以显示月份和年份。通过这种方法，可以确保图表元素按数值顺序排列，同时标签格式符合需求。
This solution can work for you ... IF ... you are able to design your report in the following fashion.
1 - Group on the date field you need.
2 - On the Insert Group screen after you have selected the date field, the third dropdown titled "The section will be printed" ... select "for each month".
3 - Click on the second tab of the Insert Group screen labeled "Options".
4 - Click the checkbox for "Customize Group Name Field".
5 - Select the second radio button labeled "Use a Formula as Group Name".
6 - Click the Conditional Format button to the right.
7 - Enter a formula like:
MonthName (Month ({Orders.Order Date}), True) &
'-' &
ToText (Year ({Orders.Order Date}), 0, '')
8 - Click OK to accept the settings.
1 - Group on the date field you need.
2 - On the Insert Group screen after you have selected the date field, the third dropdown titled "The section will be printed" ... select "for each month".
3 - Click on the second tab of the Insert Group screen labeled "Options".
4 - Click the checkbox for "Customize Group Name Field".
5 - Select the second radio button labeled "Use a Formula as Group Name".
6 - Click the Conditional Format button to the right.
7 - Enter a formula like:
MonthName (Month ({Orders.Order Date}), True) &
'-' &
ToText (Year ({Orders.Order Date}), 0, '')
8 - Click OK to accept the settings.
9 - Now add your chart. By grouping on the raw field, your chart elements will remain sorted on the numeric elements (the dates), but their labels will be in the format you requested in your posting.
扫一扫
1464
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
