BeyondBGCM
asked on
SSRS 2008
how can i export data from a report into multiple sheets , and also give each sheet the name i want
consider a case where i have a SSRS report, and now i want it to export data to Excel sheet such that , one Sub report of the report goes to one sheet of the SSRS , and another Sub report goes to another sheet and also it takes the name of subreport as the name of Excel sheet it goes to.
I am using SSRS 2008 R2
consider a case where i have a SSRS report, and now i want it to export data to Excel sheet such that , one Sub report of the report goes to one sheet of the SSRS , and another Sub report goes to another sheet and also it takes the name of subreport as the name of Excel sheet it goes to.
I am using SSRS 2008 R2
I didn't test it but it looks like you can get multiple sheets by setting page breaks after a table. So this might work with subreports also. Search Google on:
"In SSRS, After Export into excel how to give Sheet name"
(including the quotes). This describes how to get multiple sheets, but also tells you the sheets are always named 'sheet 1', 'sheet 2'. But the article is rather old so maybe this was fixed.
You can find a completely different and much more complex technique when you search Google for:
"Changing the Sheet names in SQL Server RS Excel: QnD XSLT"
This technique uses an XSLT to create an XML that represents an Excel workbook. A lot of work but very powerful.
"In SSRS, After Export into excel how to give Sheet name"
(including the quotes). This describes how to get multiple sheets, but also tells you the sheets are always named 'sheet 1', 'sheet 2'. But the article is rather old so maybe this was fixed.
You can find a completely different and much more complex technique when you search Google for:
"Changing the Sheet names in SQL Server RS Excel: QnD XSLT"
This technique uses an XSLT to create an XML that represents an Excel workbook. A lot of work but very powerful.
You might try this...
At the start and end of each sub-report make a rectrangle and place a page break inside it.
This should force a regular page break at that point.
At the start and end of each sub-report make a rectrangle and place a page break inside it.
This should force a regular page break at that point.
In tablix properties under "Page name" you can provide name of the sheet..
Check this tutorial ., it will help you sure
http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx
http://cipherdyn.wordpress.com/2013/06/11/excel-sheets-exported-from-ssrs-can-have-custom-name/
http://www.bidn.com/blogs/bretupdegraff/bidn-blog/234/new-features-of-ssrs-2008-r2-part-1-naming-excel-sheets-when-exporting-reports
Check this tutorial ., it will help you sure
http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx
http://cipherdyn.wordpress.com/2013/06/11/excel-sheets-exported-from-ssrs-can-have-custom-name/
http://www.bidn.com/blogs/bretupdegraff/bidn-blog/234/new-features-of-ssrs-2008-r2-part-1-naming-excel-sheets-when-exporting-reports
ASKER
Can you provide a working solution , which you have tried yourself , i have searched these links on google , myself , and they are not working for me .
I request to provide a solution which you have tried with yourself ,i search google links and after that i post my question here. :)
I request to provide a solution which you have tried with yourself ,i search google links and after that i post my question here. :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SELECT * FROM OPENROWSET('Microsoft.Jet.