I am designing a rdlc report.
我正在设计一份rdlc报告。
Currently the report is displaying as
目前报告显示为
Basically it is a grouped date The Schema of group is as
基本上它是一个分组日期。组的模式是
-
Work DescriptionandNo of hoursare grouped byproject id - 工作描述和小时数按项目ID分组
- Then
project idis grouped bydate of work - 然后项目ID按工作日期分组
I want to show all the grouped records by date separately. Like:
我想分别按日期显示所有分组记录。喜欢：
So how do i achive this pattern.
那么我如何实现这种模式呢？
1 个解决方案
#1
0
Add a group footer row to the group on your date column. Then merge all of the cells in that row together. (Select all of the cells, right-click, and select "Merge cells").
将组页脚行添加到日期列的组中。然后将该行中的所有单元格合并在一起。 （选择所有单元格，右键单击，然后选择“合并单元格”）。
Then you need to turn off all of the border lines for the merged cell. This is done a bit differently depending on the version of SSRS you're developing in. But it can always be done from the toolbar at the top.
然后，您需要关闭合并单元格的所有边框线。根据您正在开发的SSRS版本，这样做会有所不同。但它始终可以从顶部的工具栏完成。
The button you're looking for looks like a square sectioned into quarters. Next to it will be the options for the colour, thickness, and style of the borders. Clicking the box icon will drop-down a menu where you can select "No border" which will set all of the border styles for each side of the cell to "None".
你正在寻找的按钮看起来就像是一个四分之一的方形。旁边将是边框颜色，粗细和样式的选项。单击框图标将下拉菜单，您可以在其中选择“无边框”，将单元格每侧的所有边框样式设置为“无”。
If you find you still have a border on the left and right side of the cell it is because there is a border around the tablix control itself. Turn off that border and you should get the effect you want.
如果您发现单元格的左侧和右侧仍然有边框，那是因为tablix控件本身周围有边框。关闭边框，你应该得到你想要的效果。
You may need to mess with the border properties of some of the nearby cells if you're having issues. I've always found working with the cell borders in SSRS to be a bit fiddly but you the design you're after is certainly possible.
如果您遇到问题，可能需要弄乱附近某些单元格的边框属性。我总是发现在SSRS中使用单元格边框有点繁琐，但是你所依赖的设计肯定是可能的。
Another way to achieve this would be to nest the table control inside of a list control and group the list control on the date. Add a bit of space below the table before the edge of the list. That way when the list repeats the table there is a space between them.
实现此目的的另一种方法是将表控件嵌套在列表控件中，并在日期上对列表控件进行分组。在列表边缘之前的表格下方添加一些空格。这样，当列表重复表格时，它们之间就有一个空格。
The table will only show records that are in the current group for the list control so you don't need to add any additional filtering on the table.
该表将仅显示列表控件的当前组中的记录，因此您无需在表上添加任何其他过滤。
#1
0
Add a group footer row to the group on your date column. Then merge all of the cells in that row together. (Select all of the cells, right-click, and select "Merge cells").
将组页脚行添加到日期列的组中。然后将该行中的所有单元格合并在一起。 （选择所有单元格，右键单击，然后选择“合并单元格”）。
Then you need to turn off all of the border lines for the merged cell. This is done a bit differently depending on the version of SSRS you're developing in. But it can always be done from the toolbar at the top.
然后，您需要关闭合并单元格的所有边框线。根据您正在开发的SSRS版本，这样做会有所不同。但它始终可以从顶部的工具栏完成。
The button you're looking for looks like a square sectioned into quarters. Next to it will be the options for the colour, thickness, and style of the borders. Clicking the box icon will drop-down a menu where you can select "No border" which will set all of the border styles for each side of the cell to "None".
你正在寻找的按钮看起来就像是一个四分之一的方形。旁边将是边框颜色，粗细和样式的选项。单击框图标将下拉菜单，您可以在其中选择“无边框”，将单元格每侧的所有边框样式设置为“无”。
If you find you still have a border on the left and right side of the cell it is because there is a border around the tablix control itself. Turn off that border and you should get the effect you want.
如果您发现单元格的左侧和右侧仍然有边框，那是因为tablix控件本身周围有边框。关闭边框，你应该得到你想要的效果。
You may need to mess with the border properties of some of the nearby cells if you're having issues. I've always found working with the cell borders in SSRS to be a bit fiddly but you the design you're after is certainly possible.
如果您遇到问题，可能需要弄乱附近某些单元格的边框属性。我总是发现在SSRS中使用单元格边框有点繁琐，但是你所依赖的设计肯定是可能的。
Another way to achieve this would be to nest the table control inside of a list control and group the list control on the date. Add a bit of space below the table before the edge of the list. That way when the list repeats the table there is a space between them.
实现此目的的另一种方法是将表控件嵌套在列表控件中，并在日期上对列表控件进行分组。在列表边缘之前的表格下方添加一些空格。这样，当列表重复表格时，它们之间就有一个空格。
The table will only show records that are in the current group for the list control so you don't need to add any additional filtering on the table.
该表将仅显示列表控件的当前组中的记录，因此您无需在表上添加任何其他过滤。