How Can i Integrate a SSRS 2008 rdl report using reportviewer control in asp.net

Question

User-1170301759 posted

Hi ,

I am a novice in Reporting Services , and wanted to know how to Integrate my SSRS 2008 report in the reportviewer control in asp.net ,The path to my repot server is something like this http://ctsinhydviscdb/Reports_MSSQLSERVER2008/ , could you please help of how i am supposed to do it.I am using Sql server reporting service 2008 and Asp.net 3.5.

It gives me the following error :

• The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
  • The request failed with HTTP status 404: Not Found.

thanks,

Mario Noronha

Answer 1

User2105670541 posted

just go to your web page and do the task below:

add a report viewer control from the toolbox

set the report server url and report path of your reoprts in reportviewer control property

now just run your page, i hope it will work. Incase more problems please refer thread below:

http://forums.asp.net/t/1465632.aspx/1

Answer 2

User-1170301759 posted

Ho do i specify the Server Url and the ReportPath in ssrs 2008 i feel i am getting a problem there

Is it possible to embed Sql server 2008 R2 reporting Service in  Visual Studio 2008 ReportViewer control

 

 

Answer 3

User2105670541 posted

Look you first need to deploy your report into reportserver or you can create them locally.

if you are hosting them on report server(which could be found in http://localhost/reports) then you must give the same name of your reportserver and then the .rdl file path in your reportserver to your REPORTVIEWER control in asp.net, you can find these setting at the topmost right section of the same control.

if you want to create report locally and later want to use them in your project then again go to that topmost right corner, there you will find option to create report, later bind the same to your reportviewer control.

and Yes you can always use ReportViewer control in asp.net to bind SSRS report :)

you can visit the link below for further reference:

http://odetocode.com/code/128.aspx

http://www.visualwebgui.com/Developers/KB/tabid/654/article/how_to_use_the_report_viewer_control_to_access_a_reporting_services_server/Default.aspx

http://msdn.microsoft.com/en-us/library/ms251671%28v=vs.80%29.aspx