Export SSRS, RDL, and RDLC reports without tiny rows, columns, and merged cells

Syncfusion ReportWriter contains additional export layouts in Word and Excel formats to eliminate the tiny rows, columns, and merged cells. The benefits of the advanced layout are,

• Overcomes the tiny rows, columns, cells, and merging problem in SSRS Excel and Word exports.
• Provides clear readability by eliminating the tiny rows, columns, cells, and merge cells.
• Allows to perform data manipulations such as apply sorting, filtering, and grouping in Excel.
• Not aligning items left and right is the most common cause of merged cells, it has been resolved with this layout.

You can create a simple ReportWriter sample in WPF with the help of getting started documentation.

Initialize the ReportWriter and set report path, data sources as in the following code example.

string reportPath = @"../../ReportTemplate/Product Catalog.rdlc";
string fileName = null;
WriterFormat format;
ReportDataSourceCollection dataSources = new ReportDataSourceCollection();
dataSources.Add(new ReportDataSource { Name = "ProductCatalog", Value = ProductCatalogSource.GetData() });
ReportWriter reportWriter = new ReportWriter(reportPath, dataSources);

Set the LayoutOption property as TopLevel in WordOptions API to export the report as Word document in non-layering layout.

Word:

fileName = "ProductCatalog.doc";
format = WriterFormat.Word;
reportWriter.WordOptions = new WordOptions();
reportWriter.WordOptions.LayoutOption = WordLayoutOptions.TopLevel;

Set the LayoutOption property as IgnoreCellMerge in ExcelOptions API to export the report as Excel document in non-layering layout.

Excel:

fileName = "ProductCatalog.xls";
format = WriterFormat.Excel;
reportWriter.ExcelOptions = new ExcelOptions();
reportWriter.ExcelOptions.LayoutOption = ExcelLayoutOptions.IgnoreCellMerge; 

Download Export Layouts sample