SQLServerCentral.com / Reporting Services / Reporting Services / How run SSRS report in excel based / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 03 Mar 2015 12:24:47 GMT20RE: How run SSRS report in excel basedhttp://www.sqlservercentral.com/Forums/Topic1489628-150-1.aspxHi,You can utilize SSRS subscription to run the report at a particular time and you will get your report in your required format too. To achieve this, you can redirect your report manager URL from your application for generating the report(Subscription). Follow the below link for more information:[url=http://www.sqlcircuit.com/2012/10/ssrs-implementation-of-file-share.html][size="2"]http://www.sqlcircuit.com/2012/10/ssrs-implementation-of-file-share.html[/size][/url]Thanks,VishalSat, 31 Aug 2013 08:29:49 GMTVishal JharwadeRE: How run SSRS report in excel basedhttp://www.sqlservercentral.com/Forums/Topic1489628-150-1.aspxI don't believe you can control the output of a report from Report Manager without using the export function. However, if you are calling the report from an application, or a link you can feed parameter values and formatting information in the URL of the link. Give this page a look for more information:[url]http://msdn.microsoft.com/en-us/library/ms152835.aspx[/url]Fri, 30 Aug 2013 07:19:04 GMTDaniel BowlinHow run SSRS report in excel basedhttp://www.sqlservercentral.com/Forums/Topic1489628-150-1.aspxHi All,I need to run the report in SSRS in excel based and not based on web based.So for example I have created one report - Called A.For this report - i have got one URL as well.So by using this URL i can run my report in portal and later on I can download this as excel or CSV format.Now i have below query.When I ran this query in portal, it should ask two things 1) whether to run in portal itself 2) Run this report in excel.When i am trying to run this report in excel then where should it ask for portal parameters?Will it ask in the portal itself or else when the excel opens will it ask me to enter the parameters?Kindly let me know your views on this?Thu, 29 Aug 2013 04:01:45 GMTTomGuide