change the sheet name while exporting sql data to excel

i have designed a rdl form which contains 3 tables .. i gave page break for each table. when exporting the file to excel it generates 3 sheets .. three sheets name comes like sheet 1, sheet2 ,sheet3.. i dont want it to be like these.. instead of that i have to give my own name while generating reports from rdl form like this (s1,s2,s3)...

it is not possible to change the sheet name but have a label (Label property) for each table and that will give you document map in the excel sheet.

Shyam

|||

T hank you brother...

|||

Hi,

Thank you for the Tip.

Another question in the Document Map it creates an entry for the report Name and adds all the labels for that report.

Is it possible to change the report name in the document map without chainging it for the file?

Thank you,

Paul

Just found That http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=207848&SiteID=17