Last post Jun 11, 2014 05:33 AM by multiplex7777
Jun 02, 2014 12:01 AM|multiplex7777|LINK
I am trying to get my SSRS Table Report (an .rdl file) to display in my ASP.Net web form using the ReportViewer control?
I have followed the steps in the
Create a Basic Table Report (SSRS Tutorial) to create a table report. My table report is saved as SalesOrders.rdl. I have also successfully
added a ReportViewer control to my ASP.Net web form.
1. Should I configure ReportViewer for Local Processing or Remote Processing?
2. Either way, how do I get the ReportViewer control to read my SalesOrders.rdl file?
3. I am stuck at ReportViewer Tasks > Choose Report. I only see the option to select Server Report. What should be the report server URL? What should the Report Path be?
Thanks for the help.
Jun 02, 2014 01:13 PM|jesalynolson|LINK
If you go to the Reporting Services Configuration Manager, you should be able to go to Report Manager URL. You will want to click on the URL and upload your RDL here. This uploads it to the Report Server. From there you can input your ReportServer URL
which is how two and three of your questions work.
Here are some articles about the report manager and uploading a report:
For question one, you can use either mode, just look at the articles here:
Jun 03, 2014 04:16 AM|multiplex7777|LINK
Thanks jesalynolson. I've gone to your Upload Report and Report Manager links, but both require me to have a Report Manager URL.
So I launched my Reporting Services Configuration Manager (SQL Server 2014) and;
If I choose the option 'Create a new report server database', I end up creating a new database, which is separate from the AdventureWorks2012 database that my report is supposed to read off.
If I open my Report Server URL (http://computername/Reports) (where 'computername' is my Computer Name), I get an error:
"User 'mydomain\myusername' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed."
How do I generate a working Report Manager URL?
Jun 03, 2014 02:51 PM|jesalynolson|LINK
Yes, the Report Server database is its own distinct database. It only holds the information for those reports that you want to host in a report server. When you create the report that is where you actually point to what database you want to pull the data
from. The RDL gets stored with the Report Server database. The Report Manager is a nice way to see those files that you stored in the Report Server.
If you want to use your report with Report Viewer or a different application, it is easiest to have a report server.
Report Server Information
Let me know if you this helps or if you have any other questions.
Jun 04, 2014 01:55 AM|multiplex7777|LINK
Thanks for the useful explanation. I was having difficulty accessing the Report Server URL. I was getting a permissions error. I managed to resolve this by following the instructions
here. Had to launch IE as Administrator and then assign the permissions to myself.
Jun 04, 2014 03:22 AM|multiplex7777|LINK
I uploaded the report (Sales Orders.rdl) using Report Manager (didn't specify any particular path). What should I set the "Report Path" to in the ASP.Net ReportViewer control? I set it as:
<ServerReport ReportServerUrl="http://servername/Reports" ReportPath="/Sales Orders" />
But when I run the app, I get the 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.
Jun 11, 2014 05:33 AM|multiplex7777|LINK
Can anyone help, please?