How run SSRS report in excel based

  • Hi 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?

  • I 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:

    http://msdn.microsoft.com/en-us/library/ms152835.aspx

  • Hi,

    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:

    http://www.sqlcircuit.com/2012/10/ssrs-implementation-of-file-share.html

    Thanks,

    Vishal

Viewing 3 posts - 1 through 2 (of 2 total)

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