Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How run SSRS report in excel based Expand / Collapse
Author
Message
Posted Thursday, August 29, 2013 4:01 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 05, 2013 6:12 AM
Points: 30, Visits: 76
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?
Post #1489628
Posted Friday, August 30, 2013 7:19 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:16 PM
Points: 2,812, Visits: 2,543
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
Post #1490147
Posted Saturday, August 31, 2013 8:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 23, 2013 11:19 PM
Points: 5, Visits: 52
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
Post #1490390
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse