CODEWITHSUNDEEP
ssrs-2008
Thomas
Thomas

Reputation: 34188

SSRS report export to excel and give a sheet name issue

I am working with a local report in report viewer from VS2010.

The RDLC has more than one control on it and I am setting the PageBreakAtEnd propery to True in order to force a soft page break which also results in a 2nd Excel sheet being produced when the user exports to Excel.

However, the sheets in excel are called 'Sheet 1' and 'Sheet 2'.

How can I give sheet name. so i search google and found a link http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx from this link i came to know that it is possible. there is property called pagename. i am designing report from VS2010 but i could not found pagename property. so anyone can tell me where is the pagename property exist.

Thanks,

Upvotes: 1

Views: 9489

Answers (2)

Chris Ji
Chris Ji

Reputation: 163

There are many tutorial on how to change the PageName field to set the tab name for excel export, but they all tend to miss a very important setting for the SSRS project you are working on:

Solution Explorer –> Right click the project name and select Properties –> TargetServerVersion.

Change it to “SQL Server 2008 R2″.

Without this setting, pageName field you set will not show up on the excel export as the tab name. Hope this help someone like me dealing with an old project.

Upvotes: 3

Samuel Vanga
Samuel Vanga

Reputation: 501

Page Name property is introduced with 2008 R2. Are you working on SQL2008R2? Below is a blog post walking through steps: Page Name SSRS 2008R2

Upvotes: 3

Related Questions