Unable to display the report :(

  • This is Adrianne. I have a problem in displaying my report. This is the link of the reports prototype that we've made http://epm.misnet.com.ph/epm and http://epm.misnet.com.ph/epmreports . Here in our office or inside the network, I can view the page as well as the report that will be generated after filling up all the listboxes then clicking the "view report" button. In short, everything is doing well. But if you are outside our network and you visit the link, the page will display but the report won't. If you click the "view report" button, the message "Report is being generated" will display but it won't show the report. I've already check the database connection. How am I going to fix this problem? Can somebody help me pls.....

  • I would guess that somewhere along the line between the web server, report services and sql server some privileges are required that the session doesnt have! judging by the message I'd take a look at the web site report services is being hosted by it looks like its got anonymous access turned off, once youve added this youll neeed to enable anonymous access for rs as well i would think.


    Phil Nicholas

  • Thanks for your reply!!  But I've already turned on the anonymous access of my website in IIS. But I still have this problem. How am I goin' to unable the anonymous access for RS? 

  • have you tried restarting iis?


    Phil Nicholas

  • Yes, I've tried restarting IIS but nothing happens.

  • Check your URL address when you try to open your report, it must point to

    http://epm.misnet.com.ph/epmreports. It point to your internal RS, that's why you can

    not open report from internet. It shows your list is because IIS is working.

    check your config file. RSWebApplication.config under ReportManager

    change

    http://yourserver/reportserver

    to

    http://epm.misnet.com.ph/reportserver

  • Hi Greg! I already did what you've told me. I've modified the config file. RSWebApplication.config and changed the http://yourserver/reportserver

    to http://epm.misnet.com.ph/reportserver. But I still get the same error. I also turned on and turned off the anonymous access in IIS but nothing happens. I've checked the permissions in report manager and I made sure that the users have a browsing permission. I also did a user/login for the end-users in the database where my report is connecting. Pls help.... I don't know what else to do.

  • Have you checked your RS log files?  Maybe a check of the even log could also shed some light on whats happening?

    Steve.

  • its strange i tried your page yesterday & it was working?? the parameters came up & the report started to render, didnt wait to see the results so I assumed everything was ok


    Phil Nicholas

  • Yes Phil, my page is working, the parameters come up, the report started to render BUT the report result doesn't come up, the word "report is being generated" always display.

  • Have you now secured this site/page?  Everytime i try the url it wants authentication for the machine at 192.168.2.120 (internal ip i'm guessing?)

    Steve.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply