rmmoore80
Posts:9
 |
| 10/07/2008 12:52 |
|
Hello,
I am trying to configure the demo of the SSRS Module. Everything seems to be going fine except when I go to generate a report in DNN the images do not load and the report itself never loads. It shows up in Settings and I can browse the folder and report structure if I allow the user to select the report, but no reports ever actually work in DNN. They work perfectly in other applications or in the Reports and ReportServer applications. Any idea what could be missing?
I can provide screenshots if need be.
Ryan M. Moore
|
|
|
|
|
host
Posts:497
|
| 10/07/2008 13:44 |
|
| What version of SQL RS are you using? |
|
|
|
|
host
Posts:497
|
| 10/07/2008 13:44 |
|
| and what browser? |
|
|
|
|
rmmoore80
Posts:9
|
| 10/07/2008 21:16 |
|
We use SSRS 2008 that came with SQL 2008. I'm running IE 7 on Vista SP1. |
|
|
|
|
rmmoore80
Posts:9
|
| 10/07/2008 21:16 |
|
| FYI - The same reports work in IE7 running on the same IIS in non-DNN apps. |
|
|
|
|
host
Posts:497
|
| 10/07/2008 21:38 |
|
| Interesting, this is exactly the setup we developed on. Can you screenshot or get us access to see this in your environment? |
|
|
|
|
rmmoore80
Posts:9
|
| 10/07/2008 22:00 |
|
| Sure, do I have access to attach screenshots here some how? |
|
|
|
|
rmmoore80
Posts:9
|
| 10/08/2008 11:26 |
|
| You can view the Screenshot at http://www.ryanmoore.com/images/SSRS MM.jpg |
|
|
|
|
host
Posts:497
|
| 10/08/2008 13:09 |
|
| What is your DNN version? This is a strange one...we will have to miror your environment. Also, have you tried IE6 or Mozilla? |
|
|
|
|
rmmoore80
Posts:9
|
|
rmmoore80
Posts:9
|
| 10/08/2008 15:03 |
|
Does IIS7 need something different in the webconfig to support this? |
|
|
|
|
rmmoore80
Posts:9
|
| 10/08/2008 15:17 |
|
I added the following line to my IIS7 only section and it fixed my problem.
|
|
|
|
|
rmmoore80
Posts:9
|
| 10/08/2008 15:17 |
|
well shoot...it doesn't like my code. I replaced the less than and greater than's with exclamations.
!add name="ReportViewerHandler" path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" preCondition="integratedMode,runtimeVersionv2.0" /! |
|
|
|
|
host
Posts:497
|
| 10/08/2008 15:18 |
|
| Interesting, do you have the reportviewer handler registered in the web.config? Also, have you tried using one of the default DNN containers rather than the one you have now? Same goes for a skin. Try plopping this module on a page using the default DNN skin / container. Also, what version of DNN is this? |
|
|
|
|
host
Posts:497
|
| 10/08/2008 15:19 |
|
| There you go :) |
|
|
|
|
mmolter
Posts:13
|
| 10/12/2008 01:21 |
|
We are having a similiar problem of reports not loading. Having read the messages here, i'm a little unclear what the solution was. Did you add the code to the web.config? Was it the module skin?
Any help would be appreciated. Thx.
|
|
|
|
|
host
Posts:497
|
| 10/13/2008 08:07 |
|
| Did you load the report viewer handler in your web.config? See the doucmentation, it has the line you have to add. |
|
|
|
|
mmolter
Posts:13
|
| 10/13/2008 11:13 |
|
Yes as indicated by the documentation, this was added to the web config <httpHandlers>
<add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false"/>
httpHandlers> |
|
|
|
|
host
Posts:497
|
| 10/13/2008 13:05 |
|
| Is your problem identical to this where the report doesn't display properly or not at all? can you email us a screenshot? |
|
|
|
|
mmolter
Posts:13
|
| 10/13/2008 13:10 |
|
| I did email you. service@modulemasters.com. The report doesn't display any of the data, I can still see the parameters to input what to view, but when you click "view report" it doesn't display. There are javascript errors down at the bottom. |
|
|
|
|
host
Posts:497
|
| 10/13/2008 13:47 |
|
| Never got the email, please resend. Also, what version of DNN are you on? have you tried using default container and skin to ensure nothing is going on with the skin / container level that is impacting the control? |
|
|
|
|
mmolter
Posts:13
|
| 10/13/2008 14:56 |
|
| email resent. |
|
|
|
|
host
Posts:497
|
| 10/13/2008 15:12 |
|
| Weird, nothing has come through yet, can you please try sending to service@beckersolutions.com? |
|
|
|
|
host
Posts:497
|
| 10/15/2008 00:23 |
|
Alright, it looks like something changed somewhere in 4.8X so now what you have to do is add two lines to your web.cofig instead of one line for the reportviewer control.
First in the < system.web > section
< add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false" />
and then in the section
< httpHandlers > < add name="ReportViewerHandler" path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" preCondition="integratedMode,runtimeVersionv2.0" /> < /httpHandlers >
Notice that the system.webServer section is new and the handler is slightly different.
|
|
|
|
|