I am using .NET 3.5 reportviwer control to export a report to excel. I am binding values from a Dataset.
I am using Hide Duplicates option to Hide duplicate values in a column. Data is present only the first cell and it is hidden in the othere cells below it.
I want to Merge those cells in to a single cell and vertical align the text to centre.
How to merge cells in a column if it has duplicate values?
I also want to highlight the border when the next set of records begin? (that is at the end of the group of merged cells)
ashok.k
Member
94 Points
150 Posts
Merging cell only when duplicate values exists
Mar 10, 2009 03:44 PM|LINK
Hi
I am using .NET 3.5 reportviwer control to export a report to excel. I am binding values from a Dataset.
I am using Hide Duplicates option to Hide duplicate values in a column. Data is present only the first cell and it is hidden in the othere cells below it.
I want to Merge those cells in to a single cell and vertical align the text to centre.
How to merge cells in a column if it has duplicate values?
I also want to highlight the border when the next set of records begin? (that is at the end of the group of merged cells)
Thanks
Ashok