Solved

SSRS report not displaying on Web Page

Posted on 2010-08-31
9
756 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

 

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

705 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