for any button click event

Hi All,

I am new to sql server 2005.

I have developed an new report using sql server 2005

repoting services in Business intelligent Development studio

so any one can help me how to include this report

on any aspx page

ex for any button click event the report must be generated.

So please any one of you help me out.

Sandy,

From the FAQ's at: http://www.microsoft.com/sql/technologies/reporting/faq.mspx

Q. How can I add Reporting Services reports to my application?

A. Visual Studio 2005 (Standard and Enterprise editions) contains a set of freely redistributable Report Viewer controls that make it easy to embed Reporting Services functionality into custom applications. Two versions of the Report Viewer exist, one for rich Windows client applications and one for ASP.NET applications.

If you want more granular control, once the report is published to the report server you will notice that it has a URL. Simple link to that URL with a hyperlink, or, do a response.redirect or server.transfer on a button's click event. Once you have the full url to the report you can start playing with it to get the results you want. (i.e. Button 1 passes parameter(s) A, button2 passes parameter(s) B etc.)

For more guidence I suggest:

http://msdn2.microsoft.com/en-us/library/ms365308.aspx

http://www.microsoft.com/sql/technologies/reporting/default.mspx