I have developed some reports in SSRS (with parameters pass in to Stored Procedure to get the result dynamically). Now, I want to have something like a click of button/link from my ASP.Net pages and it will prompt user to either "Save" or "Open" the report directly in Excel. I know I have options to displayed the reports first and then let user select from the dropdown list which format to export the report. But I don't want this. What I want is once user click on the link, user will have options as mentioned above. Thanks for any help..

You can use a text box and put an action on it action will be a jump to a URL and URL will be export to excel. how to put URL in for excel export see following post http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/e4d99b03-e82d-4643-87dc-920bcb5644a3 Gaurav Gupta http://sqlservermsbiblog.blogspot.com/