Solved

SSRS report not displaying on Web Page

Posted on 2010-08-31
9
749 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
Comment Utility
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
Comment Utility
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
Comment Utility
Hi

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

Regards
Emil
0
 

Author Comment

by:cimscims
Comment Utility
Report name is 'Maintenance_Report'
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 10

Expert Comment

by:itcouple
Comment Utility
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
Comment Utility
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 500 total points
Comment Utility
0
 

Author Comment

by:cimscims
Comment Utility
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
Comment Utility
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now