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

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)...

Sorry, but this isn't supported yet.

Jarret

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

change the sheet name while exporting datagrid data to

Hi,
I am having trouble renaming the excel sheet while exporting to excel.
we have a rdl file that contains some analytical data. I have the name to the
excel file as "temp.xls" inside the code. When the user clicks on the Export
to Excel button next to datagrid, it opens a popup with options Open, Save
and Cancel. When I click open, it opens the excel sheet with the sheet name
as .xls[temp[1] and the excel filename as temp[1].xls. As a result when the
user selects the data and try to use pivot table with that data it is giving
an error. I am thinking if I change the sheetname, then the pivot table would
work. Please let me know.
Thanks,
raj.
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.comI use xslt to auto name the sheets.
<Worksheet>
<xsl:attribute name="ss:Name">
<xsl:value-of select="yourSheetName"/>
</xsl:attribute>
I export from Gridview to Excel, where I may have 100 sheets in my Excel so each sheet has a unique name.
Also see: george wesolowski's net blog and do a search on "excel" or "xslt".
Lynne
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com