forum.venkateswarlu.net
      Register      Login
How to Named Excelsheet while export SSRS report

1 replies to this topic

Kalyan Suman #1
Member
150 Points
 Posted on 16 Sep 2015 01:05 PM IST

I have 6 report want to upload into excel sheet

i created 6 reports & i added as sub reports its working fine and exporting also good

main problem am facing is

i got excel report as sheet1,sheet2,---sheet6

but i want named excel sheet please any one suggest

Thank you
Kalyan

 
SSRS     974 views     Reply to this topic
Kamalesh Kumar #2
Member
30 Points
 Replied on 18 Feb 2016 01:10 PM IST

To export to different sheets and use custom names, as of SQL Server
2008 R2 this can be done using a combination of grouping, page breaks
and the pagename property of the group.Alternatively, if it's just the single sheet that you'd like to give a specific name, try the initial pagename  property on the report.

 
Reply to this topic