I am working on a new RDLC report (as part of a WinForms application) and I need to have the report take a simple table (6 columns of simple data), and for each row in the table, display a box that contains that data, but arranged such that the first two "rows" in that box consist of first an image (two "cells" merged vertically) and then two values (above each other - each on their own "row"). Then it needs to include 3 values (as separate "rows" as wide as the entire box (i.e. merging the two cells horizontally)
And it needs to repeat that entire box for every row of data.
How can I accomplish this, given that it includes both horizontal and vertical merging of cells (and I'm not sure how to do that in either a table or matrix in the RDLC)?
Here is a mock-up of this, to better show what I need:
To merge cells vertically, select the cells or columns you want to merge, right-click, and select Merge Vertically. To merge all selected cells in both multiple rows and columns, select the cells you want to merge, right-click, and select Merge All.
You can combine two or more table cells located in the same row or column into a single cell. For example, you can merge several cells horizontally to create a table heading that spans several columns. Select the cells that you want to merge. Under Table Tools, on the Layout tab, in the Merge group, click Merge Cells.
Holding the left mouse button down, drag vertically or horizontally to select adjacent cells. The selected cells are highlighted. Right-click the selected cells and select Merge Cells. The selected cells are combined into a single cell.
I found a solution on this page
By the default, a single row header is created when adding a grouping or field in a Tablix. In order to merge two cells of two rows in a column, try the following steps:
Note: The following will only work if the "Row Header was generated by adding a parent or child group". If this was just dragged from a dataset, you will never see the merged cell option.
- Insert a row above the single row header (again this is grouping header). The original header at this point will be in the second row.
- Select the adjacent cells vertically (e.g. two cells of two rows in a column) by using pressing Ctrl key and Clicking on the Cell. The selection should be highlighted by a dark grey thick border around the edges.
- Right-Click on your selection in the whitespace area, you should "Merge Cells" in the popup menu. Select "Merge Cells".
- The two adjacent vertical cells are merged at this stage. You need to write label text again as the merging will erase it. To center the text, you can just press enter first and normally it will center.
- Do this to the other columns that you need to merge.
To achive this veritcle merging need two Tablix .
In fact we use multiple Tablix to drag and drop what we need.
For acheive this you need adjust size of the cells to get perfect shape.
Look two simple steps how we did this.
Note: Main Tablix dataset is supplied to inside Tablix
See example image:]2
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With