Solved

SSRS report not displaying on Web Page

Posted on 2010-08-31
9
751 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
 

Author Comment

by:cimscims
ID: 33571312
Report name is 'Maintenance_Report'
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
asp.net mvc return json 2 56
Jquey and footrable 2 35
Resolve Dependency Issues 4 45
Not showing JavaScript in the list 5 37
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

910 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

20 Experts available now in Live!

Get 1:1 Help Now