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?