locked
displaying a report in server using report viewer VS 2010 RRS feed

  • Question

  • User-1907569630 posted

     We hosted new website, in that I created 3 reports using asp.net
     MS-report (report viewer).

    I published this locally and it is working great, but same thing I copied to server now its not displaying the report and it's asking for authentication. After providing username and password, it's simply showing a blank page.

    And also manually I
     transferred all **.rdlc** files into report folder with I copied data set
     to application folder.
     
     And here is my `web.config`:

        <?xml version="1.0"?>
        <!-- For more information on how to configure your ASP.NET application, please visit http://go.microsoft.com/fwlink/?LinkId=169433 -->
        <configuration>
            <appSettings>
                <add key="CrystalImageCleaner-AutoStart" value="true" />
                <add key="CrystalImageCleaner-Sleep" value="60000" />
                <add key="CrystalImageCleaner-Age" value="120000" />
            </appSettings>
            <system.web>
                <sessionState timeout="20"/>
                <compilation targetFramework="4.0">
                    <assemblies>
                        <add assembly="CrystalDecisions.CrystalReports.Engine, Version=13.0.2000.0, ulture=neutral, PublicKeyToken=692fbea5521e1304"/>
                        <add assembly="CrystalDecisions.ReportSource, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />
                        <add assembly="CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />
                        <add assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />
                        <add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />
                        <add assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
                        <add assembly="Microsoft.ReportViewer.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
                        <add assembly="Microsoft.Build.Framework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
                        <add assembly="System.Management, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
                    </assemblies>
                    <buildProviders>
                        <add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
                    </buildProviders>
                </compilation>
                <globalization requestEncoding="iso-8859-1" responseEncoding="iso-8859-1" />
                <httpHandlers>
                    <add path="CrystalImageHandler.aspx" verb="GET" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />
                    <add path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" validate="false" />
                </httpHandlers>
            </system.web>
            <connectionStrings>
                <add name="constr" connectionString="Data Source=SQLEXPRESS; Initial Catalog =databasename; User Id = user; Password = pwd;" />
                <add name="iCAMSConnectionString" connectionString="Data Source=SQLEXPRESS;Initial Catalog=databasename;Persist Security Info=True;User ID=user;Password=pwd" providerName="System.Data.SqlClient" />
            </connectionStrings>
            <system.webServer>
                <handlers>
                    <add name="CrystalImageHandler.aspx_GET" verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" preCondition="integratedMode" />
                    <add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
                </handlers>
                <validation validateIntegratedModeConfiguration="false" />
            </system.webServer>
        </configuration>

     
     
     And I kept all **.dll** in `bin`, for example:

        Microsoft.ReportViewer.WebForms
        Microsoft.ReportViewer.Common

     
     and reports(.rdlc) in report folder
     
     Please any one can help me, I tried lot but i don't know where I am
     missing.

    Thank you.

    Friday, March 2, 2012 5:42 AM

All replies

  • User1274561869 posted

    Hi

    Please refer to this link:

    http://msdn.microsoft.com/en-us/library/ms251661(v=vs.80).aspx

    Hope it helpful.

    Sunday, March 4, 2012 10:36 PM
  • User-1907569630 posted

    Sorry for the delay in reply, Thank you i got it in some other way.

    first of all i don't know what is the difference between publishing & deploying application.

    previousely i published & uploded that time its not working, but after deploying & upload its working correctly.

    i waited 3 days but no one answered, but i'm thankful to your reply.

    Regards,

    SJK.

    Wednesday, March 7, 2012 7:00 AM