合并重复(行组)列单元格 [英] Merge duplicate (row group) column cells
问题描述
ID| Date1 | Date 2 |Total
-----------------------------------
1 | 15/02/2017 |02/02/2017 | 3 |
-----------------------------------
1 | 15/02/2017 |05/08/2017 | 3 |
-----------------------------------
1 | 15/02/2017 |12/12/2017 | 3 |
-----------------------------------
2 | 12/05/2017 |07/08/2017 | 2 |
-----------------------------------
2 | 12/05/2017 |10/08/2017 | 2 |
<小时>
我有一个表格,上面显示数据.我正在将这些数据分组在ID"列上.列Date1"& 的值特定ID"的总计"相同,但给定组中的Date2"值可能不同.
I have a table that is displaying data like above. I'm grouping that data on "ID" column. Values for Columns "Date1" & "Total" for a particular "ID" are the same but "Date2" value can be different in a given group.
当值相同时,如何跨行合并单元格,使其显示如下?
How can i merge the cells across rows when the values are the same such that it displays like below?
ID| Date1 | Date 2 |Total
-----------------------------------
1 | 15/02/2017 |02/02/2017 | 3 |
--| |------------| |
1 | |05/08/2017 | |
--| |------------| |
1 | |12/12/2017 | |
---------------------------------|
2 | 12/05/2017 |07/08/2017 | 2 |
--| |------------| |
2 | |10/08/2017 | |
<小时>
我确实设法找到了HideDuplicates"TextBox 属性,但是虽然这会抑制相邻行中单元格值的重复,但它不会跨行合并列中的那些重复单元格
I did manage to find that "HideDuplicates" TextBox property, but while that will suppress the repetition of the cell values in adjacent rows it does not merge those duplicate cells down the column across rows
推荐答案
如果没有看到设计,很难说出报告是如何设置的,但从头开始做起来非常简单.
Its difficult to tell how the report is setup in terms of groups etc without seeing the design, but this is pretty simple to do from scratch.
从一个只有详细信息行的简单表格开始,没有分组.然后在主报表设计区域下的行组面板中右键单击明细行.选择添加组 -> 父组在下拉列表中选择您的 Date1 字段.单击确定",您就完成了.
Start with a simple table with just your detail rows, no grouping. Then right-click the detail row in the row group panel under the main report design area. Choose Add Group -> Parent Group Choose your Date1 field in the group by drop down . Click OK and you're done.
这篇关于合并重复(行组)列单元格的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!