?
Solved

SSRS report not displaying on Web Page

Posted on 2010-08-31
9
Medium Priority
?
776 Views
Last Modified: 2012-05-10
I have created a server report(XYZ.rdl) and published it on the server. When i tried to run from the ASP.NET application, it is not throwing any error and not displaying the report on the web page.

On the web page, i have report viewer and a submit button. When user clicks on the Submit button, i have to display the report.

This is the code i used in the Submit click

ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://X8989/ReportServer_DEVSQL99")
ReportViewer1.ServerReport.ReportPath = "/Inventory/Maintenance_Report"
ReportViewer1.ServerReport.Refresh
ReportViewer1.Visible=true

Any help?
0
Comment
Question by:cimscims
9 Comments
 
LVL 14

Expert Comment

by:Emes
ID: 33570954
can you run the script from Management Studio as the same user from the web.

the web user may not have rights to the data.
0
 

Author Comment

by:cimscims
ID: 33571048
Iran the report from the report manager.it was fine.how should I run from the management studio?
So, do I need to provide any credentials to the reportviewer?
0
 
LVL 10

Expert Comment

by:itcouple
ID: 33571237
Hi

I don't see report name anywhere in the code ;)

Regards
Emil
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:cimscims
ID: 33571312
Report name is 'Maintenance_Report'
0
 
LVL 10

Expert Comment

by:itcouple
ID: 33571449
Hi

If it doesn't display at all then check if you have appropriate handlers and assembliest in your web.config file. I reraly use reportviewe/asp.net so cannot provide much details but I do remember having similar issue which was resolved by changing web.config file.

Regards
Emil
0
 

Author Comment

by:cimscims
ID: 33571525
I am on the way going home.I will check tomorrow and shall post.thanks for your time.
0
 
LVL 9

Accepted Solution

by:
sureshbabukrish earned 2000 total points
ID: 33574967
0
 

Author Comment

by:cimscims
ID: 33576513
I followed the same article to generate the report. Only thing i have removed is the Credential section.

I didn't understand the below one:
Password of the Folder this is the password for that folder on the report server

Where to set this password for the folder?
0
 

Author Comment

by:cimscims
ID: 33576747
It worked !!

I haven't used the Credential section. Instead i just used the below code.

ReportViewer1.ShowCredentialPrompts = false
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote
ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://X8989/ReportServer_DEVSQL99")
ReportViewer1.ServerReport.ReportPath = "/Inventory/Maintenance_Report"

0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question