Exporting Directly to Excel

Question

Post reply

Exporting Directly to Excel

jaimearqueza

Valued Member

Points: 68
More actions
November 19, 2008 at 11:52 pm

#203109

Hi
Is there a way of exporting a dataset directly to Excel spreadsheet without viewing in Report Viewer using Reporting Services? Please Help..
Thanks
Jaime

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

arup chakraborty Hall of Fame Points: 3640 More actions · Answer 1

arup chakraborty

Hall of Fame

Points: 3640

November 20, 2008 at 12:04 am

#900900

U may use export-import wizard or SSIS

cavo789 Mr or Mrs. 500 Points: 503 More actions · Answer 2

In Excel, go to Data - Get external data.

MS Query will then be launched and will allow you f.i. to connect to a SQL db and to fire a T-SQL, a view, a stored procedure, ...

Christophe

Gosta Munktell SSCertifiable Points: 6004 More actions · Answer 3

There are at least two more methods.

You have to be more specific with your question.

Gosta

For better, quicker answers, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 4

jaimearqueza (11/19/2008)
Hi
Is there a way of exporting a dataset directly to Excel spreadsheet without viewing in Report Viewer using Reporting Services? Please Help..
Thanks
Jaime

use OpenRowSet to export data into Excel file. for more info: http://www.mssqltips.com/tip.asp?tip=1202

upperbognor Right there with Babe Points: 787 More actions · Answer 5

http://ReportServerURL/reportserver?ReportPath&rs:Command=Render&%5Bb%5Drs:Format=EXCEL%5B/b%5D

I think this is what you might be looking for. This will give you a direct link into the report that will open in Excel format so you do not have to use the viewer and click export to excel.

The key here is the rs:Format=Excel at the end of the URL. Other opetions if enabled are XML, CVS,Image, PDG,HTML4.0...

http://msdn.microsoft.com/en-us/library/ms154040.aspx Gives an example as well.

jaimearqueza Valued Member Points: 68 More actions · Answer 6

Hi SSC

I tried your suggestion and it seems to have a progress. However, how would I pass two parameters to it. I actually created a link from the summary page and put what you have suggested to the "Jump to url" of the link properties. This link appears at the summary page and how will I pass these parameters?

http://url/Reports/Pages/Report.aspx?ItemPath=Report%ReportName&rs:Command=Render&rs:Format=EXCEL

Thanks in advance

upperbognor Right there with Babe Points: 787 More actions · Answer 7

Books Online Reference: http://technet.microsoft.com/en-us/library/ms155391.aspx%5B/url%5D

http:// /reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=HTML4.0&rc:

Parameters=false&Year=2002

The rc:Parameters=false hide's the parameter's prompt in the report.

upperbognor Right there with Babe Points: 787 More actions · Answer 8

jaimearqueza (11/24/2008)
Hi SSC
I tried your suggestion and it seems to have a progress. However, how would I pass two parameters to it. I actually created a link from the summary page and put what you have suggested to the "Jump to url" of the link properties. This link appears at the summary page and how will I pass these parameters?
http://url/Reports/Pages/Report.aspx?ItemPath=Report%ReportName&rs:Command=Render&rs:Format=EXCEL
Thanks in advance

Make sure you use http://url/REPORTSERVER/reportpath as your link. See the Books Online example in my post above.