Search code examples
ssrs-2008

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,

Solution

  • 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