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.
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
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:
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
marionoronha...
Member
5 Points
14 Posts
How Can i Integrate a SSRS 2008 rdl report using reportviewer control in asp.net
Jan 24, 2012 06:16 AM|LINK
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 :
thanks,
Mario Noronha
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: How Can i Integrate a SSRS 2008 rdl report using reportviewer control in asp.net
Jan 24, 2012 07:05 AM|LINK
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
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
marionoronha...
Member
5 Points
14 Posts
Re: How Can i Integrate a SSRS 2008 rdl report using reportviewer control in asp.net
Jan 24, 2012 08:23 AM|LINK
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
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: How Can i Integrate a SSRS 2008 rdl report using reportviewer control in asp.net
Jan 24, 2012 05:07 PM|LINK
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
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS