locked
error on crystal reports when running RRS feed

  • Question

  • User-306584176 posted

    Hi everyone...

    I'm kindof new to crystal reports... I would like to find out that why does the app/forms run perfect when I run it from the code, but as soon as I load it onto the web the crystal reports is giving me an error. So why does it give an error once it's loaded on the ftp, but not from the app itself... This is the error that I get:

     Could not load file or assembly 'CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.
    Line 22: <add assembly="CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/>
    Line 23: <add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></assemblies><buildProviders><add extension=".rpt" type="CrystalDecisions.Web.Compilation.RptBuildProvider, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></buildProviders></compilation>
    Line 24: <httpHandlers><add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></httpHandlers></system.web>
    Line 25: <appSettings>
    Line 26:      <add key="LoginUsername" value="codex" />

    Assembly Load Trace: The following information can be helpful to determine why the assembly 'CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' could not be loaded.

    WRN: Assembly binding logging is turned OFF.
    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
    Note: There is some performance penalty associated with assembly bind failure logging.
    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

    How can I fix this? Any help will be greatly appreciated!!!


    Thursday, June 30, 2011 8:33 AM

Answers

  • User151513110 posted

    Hi link_it,

    Thanks for post your code.

    Here i am using dynamic connecting with run crystal report.

    Imports System.Data
    Imports System.Data.SqlClient
    Imports System.IO
    Imports System.Web.UI
    Imports CrystalDecisions.CrystalReports.Engine
    Imports CrystalDecisions.ReportSource
    Imports CrystalDecisions.Shared
    Partial Class _Default
        Inherits System.Web.UI.Page
        Protected Sub btnShow_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnShow.Click
            Dim cryRpt As ReportDocument = New ReportDocument
            Dim crtableLogoninfos As TableLogOnInfos = New TableLogOnInfos
            Dim crtableLogoninfo As TableLogOnInfo = New TableLogOnInfo
            Dim crConnectionInfo As ConnectionInfo = New ConnectionInfo
            Dim CrTables As Tables
            cryRpt.Load(Server.MapPath("~/Reports/Village_Report.rpt"))
            crConnectionInfo.ServerName = ConfigurationManager.AppSettings("SQLServer")
            crConnectionInfo.DatabaseName = ConfigurationManager.AppSettings("Database")
            crConnectionInfo.UserID = ConfigurationManager.AppSettings("UserId")
            crConnectionInfo.Password = ConfigurationManager.AppSettings("Password")
            crConnectionInfo.IntegratedSecurity = True
            crConnectionInfo.Type = CrystalDecisions.Shared.ConnectionInfoType.SQL
            CrTables = cryRpt.Database.Tables
            For Each CrTable As CrystalDecisions.CrystalReports.Engine.Table In CrTables
                crtableLogoninfo = CrTable.LogOnInfo
                crtableLogoninfo.ConnectionInfo = crConnectionInfo
                CrTable.ApplyLogOnInfo(crtableLogoninfo)
            Next
            CrystalReportViewer1.ReportSource = cryRpt
            CrystalReportViewer1.RefreshReport()
        End Sub
    End Class
    in web.config file
    <connectionStrings>
      <add name="VUPDBConnectionString" connectionString="Data Source=RAVI-ADMIN;Initial Catalog=VUPDB;Integrated Security=True"
       providerName="System.Data.SqlClient" />
     </connectionStrings>
     <appSettings>
      <add key="CrystalImageCleaner-AutoStart" value="true" />
      <add key="CrystalImageCleaner-Sleep" value="60000" />
      <add key="CrystalImageCleaner-Age" value="120000" />
      <add key="SQLServer" value="RAVI-ADMIN" />
      <add key="Database" value="VUPDB" />
      <add key="UserId" value="" />
      <add key="Password" value="" />
     </appSettings>
    <system.web>
    		
    		<compilation debug="true" strict="false" explicit="true">
    			<assemblies>
    				<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
    				<add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
    				<add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
    				<add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
    				<add assembly="CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
    				<add assembly="CrystalDecisions.Shared, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
    				<add assembly="CrystalDecisions.ReportSource, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
    				<add assembly="CrystalDecisions.Enterprise.Framework, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
    				<add assembly="CrystalDecisions.Enterprise.Desktop.Report, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
    				<add assembly="CrystalDecisions.ReportAppServer.Controllers, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
    				<add assembly="CrystalDecisions.CrystalReports.Engine, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
    				<add assembly="CrystalDecisions.Enterprise.InfoStore, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
    				<add assembly="CrystalDecisions.Enterprise.Viewing.ReportSource, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/><add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></assemblies>
    		</compilation>
    Mark as Answer if its help.
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 1, 2011 12:48 AM
  • User151513110 posted

    Hi, 

    link_it 

    You can download all the version of the crystal report.
    http://www.sdn.sap.com/irj/boc/support
    
    Mark as Answer if its Help.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 1, 2011 3:29 AM

All replies

  • User151513110 posted

    Hi,

    I know your problem. 

    pls send me your code. i can help easly.

    Thursday, June 30, 2011 9:03 AM
  • User-306584176 posted

    Hi Ravi!!! Thank you so very much!!! I really appreciate this!!! Thanks!!!

    <system.web>
    		<!--<authentication mode="Forms">
          <forms loginUrl="~/frmLogin.aspx" timeout="1" />
        </authentication>-->
    		<!--<sessionState timeout="1"/>-->
    		<customErrors mode="Off"/>
    		<compilation debug="true" targetFramework="4.0">
    			<assemblies>
    				<add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
    				<add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
    				<add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
    				<add assembly="CrystalDecisions.CrystalReports.Engine, Version=13.0.2000.0, Culture=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"/></assemblies><buildProviders><add extension=".rpt" type="CrystalDecisions.Web.Compilation.RptBuildProvider, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></buildProviders></compilation>
    	<httpHandlers><add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></httpHandlers></system.web>
    Thursday, June 30, 2011 9:48 AM
  • User311508580 posted

    Hi link,

    Do you host this CR on a shared server? If yes, have you contact your provider about the correct connection string? If I see the error message, it seems this is the problem with your connection string.

    Friday, July 1, 2011 12:25 AM
  • User151513110 posted

    Hi link_it,

    Thanks for post your code.

    Here i am using dynamic connecting with run crystal report.

    Imports System.Data
    Imports System.Data.SqlClient
    Imports System.IO
    Imports System.Web.UI
    Imports CrystalDecisions.CrystalReports.Engine
    Imports CrystalDecisions.ReportSource
    Imports CrystalDecisions.Shared
    Partial Class _Default
        Inherits System.Web.UI.Page
        Protected Sub btnShow_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnShow.Click
            Dim cryRpt As ReportDocument = New ReportDocument
            Dim crtableLogoninfos As TableLogOnInfos = New TableLogOnInfos
            Dim crtableLogoninfo As TableLogOnInfo = New TableLogOnInfo
            Dim crConnectionInfo As ConnectionInfo = New ConnectionInfo
            Dim CrTables As Tables
            cryRpt.Load(Server.MapPath("~/Reports/Village_Report.rpt"))
            crConnectionInfo.ServerName = ConfigurationManager.AppSettings("SQLServer")
            crConnectionInfo.DatabaseName = ConfigurationManager.AppSettings("Database")
            crConnectionInfo.UserID = ConfigurationManager.AppSettings("UserId")
            crConnectionInfo.Password = ConfigurationManager.AppSettings("Password")
            crConnectionInfo.IntegratedSecurity = True
            crConnectionInfo.Type = CrystalDecisions.Shared.ConnectionInfoType.SQL
            CrTables = cryRpt.Database.Tables
            For Each CrTable As CrystalDecisions.CrystalReports.Engine.Table In CrTables
                crtableLogoninfo = CrTable.LogOnInfo
                crtableLogoninfo.ConnectionInfo = crConnectionInfo
                CrTable.ApplyLogOnInfo(crtableLogoninfo)
            Next
            CrystalReportViewer1.ReportSource = cryRpt
            CrystalReportViewer1.RefreshReport()
        End Sub
    End Class
    in web.config file
    <connectionStrings>
      <add name="VUPDBConnectionString" connectionString="Data Source=RAVI-ADMIN;Initial Catalog=VUPDB;Integrated Security=True"
       providerName="System.Data.SqlClient" />
     </connectionStrings>
     <appSettings>
      <add key="CrystalImageCleaner-AutoStart" value="true" />
      <add key="CrystalImageCleaner-Sleep" value="60000" />
      <add key="CrystalImageCleaner-Age" value="120000" />
      <add key="SQLServer" value="RAVI-ADMIN" />
      <add key="Database" value="VUPDB" />
      <add key="UserId" value="" />
      <add key="Password" value="" />
     </appSettings>
    <system.web>
    		
    		<compilation debug="true" strict="false" explicit="true">
    			<assemblies>
    				<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
    				<add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
    				<add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
    				<add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
    				<add assembly="CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
    				<add assembly="CrystalDecisions.Shared, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
    				<add assembly="CrystalDecisions.ReportSource, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
    				<add assembly="CrystalDecisions.Enterprise.Framework, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
    				<add assembly="CrystalDecisions.Enterprise.Desktop.Report, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
    				<add assembly="CrystalDecisions.ReportAppServer.Controllers, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
    				<add assembly="CrystalDecisions.CrystalReports.Engine, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
    				<add assembly="CrystalDecisions.Enterprise.InfoStore, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>
    				<add assembly="CrystalDecisions.Enterprise.Viewing.ReportSource, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/><add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=12.0.1100.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></assemblies>
    		</compilation>
    Mark as Answer if its help.
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 1, 2011 12:48 AM
  • User-306584176 posted

    Hi Ravi! Thank you so very much for your help!!! It's still giving me an error though :Error 60 Could not load file or assembly 'CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified. C:\Users\User\Desktop\ClientWorx\18-June\ClientWorx\web.config 22 

    Okey... I think my visual studio don't have the version 12... I've looked through all the references and there is only 13... Do you know where I can download the version 12?

    Friday, July 1, 2011 2:20 AM
  • User151513110 posted

    Hi, 

    link_it 

    You can download all the version of the crystal report.
    http://www.sdn.sap.com/irj/boc/support
    
    Mark as Answer if its Help.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 1, 2011 3:29 AM
  • User-306584176 posted

    Hi Ravi_D! Thank you so very much for all your help!!! I really appreciate it!!!!

    Friday, July 1, 2011 3:43 AM