Renaming worksheets in Excel via export from Visua

Question

I' m developing reports from Visual Studio 2010 using .rdlc extension.

There is a requirement where I have to export all reports to one excel file in the form of tabs.

When I export reports to Excel I can see the reports in the form of tabs(sheet1, sheet2, ........).

I want to rename these sheets. I have seen that in SQL Server 2008 R2 there is a property PageName which I' m unable to find in Visual Studio 2010. Please help me with this.

Answer 1

You can try this out:

PageName

Set this and then on export to excel the tab will use the page name. This can be set on certain objects in the report and can use Expressions to set the name. Objects that contain this property include:

 - Tablix
 - Rectangle

Here is the tutorial for you to explore:

• Export reports to Excel with page names set