May 29, 2008 at 10:48 am
Is there a way to automatically render a report in Excel? We have a few reports that are formatted specifically for Excel and it would be nice to not make the user export the report.
May 29, 2008 at 11:26 am
if you're using a web link to access the report, just add &rs:format=excel to the url.
June 3, 2008 at 4:32 am
Correct me if this is an incomplete/wrong observation but I tried and observed that following info also needs to be present in the URL in addition to the one you've mentioned:
ReportSession,ControlID,Culture,UICulture,ReportStack,OpType,
FileName,ContentDisposition and Format=EXCEL
in order to automatically redirect the user to the exported excel.
Out of which ReportSession is dynamic!
Please comment.
June 3, 2008 at 5:23 am
we handle our own authentication and our url looks like this:
[font="arial"]http://OurServer/ReportServer/Pages/ReportViewer.aspx?
/PathAndNameOfReport&rs:Command=Render&rs:Format=EXCEL
&rc: Parameters=false&ourReportParametersAndValues[/font]
November 5, 2008 at 1:10 am
I want to export to excel by using this url:
how to get this done by not passing ReportSession & ControlID, if these are required then how to pass my own ReportSession & ControlID params.
November 6, 2008 at 11:57 am
How about a subscription? You can even go "data-driven", to send the same, or even different results, to the users via e-mail.
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply