Is it Possible to export the report to Excel Directly on some conditions.

Any help please. 

From SQL Server Reporting Services you can export to excel without any problem, on the front end you can see it on the drop down.

Thanks for your reply,

But My query is Supposed number of records I am going to shown in reports is more than say 500 then I don't want to show the out put in  Report ,But directly export to Excel showing some message to the user.
 

Hi,

There isn’t any direct way to achieve that. But I think you can subscribe the PDF/EXCEL report from the reporting service via email.

You may refer the following post:

http://forums.asp.net/t/1239724.aspx  

You may try the following articles which show the details.

http://channel9.msdn.com/ShowPost.aspx?PostID=87032
http://www.aspnettutorials.com/tutorials/email/email-attach-aspnet2-csharp.aspx

Thanks.