Solved

SSRS report not displaying on Web Page

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

 

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

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.

Question has a verified solution.

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

Suggested Solutions

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

776 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