How to determine the full-qualified name of my report after publishing?

Question

User246057125 posted

I created a report using SSRS Business Development Studio 2008. Back-end is SQL Server 2008 R2 Enterprise Edition.

I created a .rdl file and published it. Now I want to show this report on a report viewer control on a Web Form of VS-2010.

How to determine the exact Uri and fully-qualified report name? Where is the published report located? I cannot see any report in the Management Studio.

Answer 1

User2105670541 posted

you need to deploy the report on your report server, if reporting services configured on your local machine then you can find it by typing something like below in your URL:

http://localhost/reports

there you need to deploy your report, and when you want to show the report in your reportviewer control, you need to set the server address, that will be localhost in your case, and the name of reports in ReportViewer property, this is the way you'll be able to show your report in your reportviewer control.

for more info refer to the links below:

http://www.codedigest.com/Articles/ASPNET/373_Working_with_ReportViewer_Control_%20in_AspNet.aspx%20

http://msdn.microsoft.com/en-us/library/ms251723.aspx

http://odetocode.com/Articles/156.aspx

http://www.devproconnections.com/article/aspnet2/leveraging-the-asp-net-reportviewer-control

Answer 2

User246057125 posted

When I type:

http://localhost/reports

it displays: Service not available.

Answer 3

User2105670541 posted

did you configured reporting services on your local system, if not please visit the link below to configure them:

http://msdn.microsoft.com/en-us/library/bb839480(v=sql.90).aspx

http://sql-articles.com/blogs/10-minutes-to-configure-reporting-services-2008/

if you do not want to configure and want to process only locally created reports on reportviewer then please visit the link below:

http://www.codeproject.com/Articles/15597/Using-the-ASP-NET-2-0-ReportViewer-in-Local-Mode

Answer 4

User246057125 posted

Ok configured the Reporting Server.

When I right-click on the .rdl file in Business Development Studio and select "Deploy", it is giving error:

The specified TargetServerURL is not valid. Specify a valid URL for a report server in the deployment settings.

Answer 5

User2105670541 posted

in the properties pane of your report project you need to give the report server name: localhost and the report folder name if you are deploying report to any specific folder:

you can also deploy the reports to reportserver by going to

http://localhost/reports

there you will find an option to upload , from there you can also deploy the reports there.

Answer 6

User246057125 posted

Ok, so now it started working. After little trial-and-error.

Thanks.

Answer 7

User-1133898271 posted

nice article