Developed SQL reports in SSRS 2008R2. Later added to VS2010 solution(In TFS). when we try to open to RDL file in VS2010 ,its opened with XML (Text) Editor.Then we have upgraded the RDL file to open in report design mode (in VS 2010).
But some functionality is not working after upgrading RDL to VS2010.
Ex. We have Page name property in RDL to display sheet Name( while exporting to Excel sheet).
Instead of display that it will be displayed as sheet1,sheet2,…..
Please let me if any one faced such an issue & if any work around to display Excel sheet names…