Hi All, While exporting data to excel in RDLC, excel is generated with lot's of tabs instead of a single tab with data. Multiple tabs corresponds to grouping of data with page break after each group in table. My requirement is I need only one tab to be generated for all groups of data on exporting to excel. Any help is appreciated. Thanks, Jaydeep

Hi, You may not be able to change the custom export functionality of the ReportViewer. But you can hide the Export button by setting the ReportViewer.ShowExportButton propery to false and add a new button in your page to do that work. Write some .NET to customize the export functionality in the button click event. Alternatively, You can handle the ReportViewer_ReportExport event, Set the e.Cancel to true and execute your custom .NET code to customize the export function. Reference: Modifying Export to Excel in ReportViewer Creating a Custom Export to Excel for ReportViewer (rdlc) Modifying Export to Excel in ReportViewer to be readonly Microsoft MVP - ASP/ASP.NET