April 18, 2011 at 2:46 pm
Hello
I want to create an environment where I want to be able to use SSRS 2008 to return a report directly in Excel, if possible. I know of the facility to export a report to excel... but, what I really need is that if someone clicks on a particular report, instead of rendering in Report viewer, it should prompt the user to download the report in excel format.
Please let me know if that's possible? I am using SSRS 2008 R2 with Sharepoint 2010 integrated.
Thanks,
Anish
May 2, 2011 at 9:31 am
You can do that using C#/Vb.Net and Reporting webservice.. Read the Scott's blog..
Hope this helps..
May 3, 2011 at 7:44 am
It might be easier and more straight forward to use the URL Access Parameters. You can then just call the report you want from any web part that you can create hyperlinks (links, page viewer, content editor... or even the local navigation). Here is the standard MS article describing URL access parameters for SSRS:
http://technet.microsoft.com/en-us/library/ms152835.aspx
The command you are looking for in the URL is rs:Format=xls
February 18, 2014 at 7:13 am
Hello all... I have a similar problem but with 1 additional issue.
That issue is: What if user(s) set various parameters and then do not want to run the report to first be viewed in web-interface and then being given the option to export the report into excel/pdf/etc formats.
layman terms of putting this "import it directly to excel by setting the parameters"
I'm a sql developer and I know there is a asp.net solution out there that has been put by asp developer(s) found here
so is there a sql way way of doing this?
-Darkraijin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply