Crystel Report Error in VS2010

Question

0.00/5 (No votes)

See more:

When try to show Crystal Report error comes:

HTML

Could not load file or assembly 'file:///C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified.

Code for Show CrystelReport:

Dim rptInvoiceDt As New DataTable
        PrintReporObj = New DataAccessLayer
        rptInvoiceDt = PrintReporObj.Filldatatable("SELECT * FROM InvoiceReport WHERE JobListID=" & JobAndTrackingMDI.GetJobID & "")
        If rptInvoiceDt.Rows.Count = 0 Then
            KryptonMessageBox.Show("Record Not found")
        Else
            Dim Rpt As New ReportDocument
            Dim ReportPath As String = Application.StartupPath & "\Reports\rptInvoice.rpt"
            Rpt.Load(ReportPath)
            Rpt.SetDataSource(rptInvoiceDt) '<--When This Line execute the error occur -->
            CRVInvoice.ReportSource = Rpt
        End If

Posted 24-May-11 10:15am

raviprajapat

Updated 12-Aug-17 6:55am

Kenneth Haugland

v5

Add a Solution

5 solutions

Solution 5

in your application config file change this section:

<pre lang="HTML">

<startup><supportedruntime version="v4.0" sku=".NETFramework,Version=v4.0">

to

HTML

<startup>useLegacyV2RuntimeActivationPolicy="true"><supportedruntime version="v4.0" sku=".NETFramework,Version=v4.0" /></startup>

Posted 29-May-13 12:54pm

degdag

Solution 1

'file:///C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll'

In this link which "/" "\" symbole you use. Before C: / and after C: \.

Posted 24-May-11 10:27am

divesh12

Updated 30-Oct-11 21:11pm

v2

Solution 3

You can use this code. Which is working in vs2005 so it may be work in 2010.

VB

Dim rpt As New ReportDocument()
Dim DPath As String = Application.StartupPath & "\MyData.mdb" 'Data File location
rpt.Load(Application.StartupPath & "\Reports\rptInvoice.rpt") 'Report Path
For Each connection As IConnectionInfo In rpt.DataSourceConnections
    'Changing Data Source
    rpt.DataSourceConnections(connection.ServerName, connection.DatabaseName).SetConnection(DPath, "", "", "")
Next
rpt.RecordSelectionFormula = "{InvoiceReport.JobListID}=" & JobAndTrackingMDI.GetJobID & ""
If (rpt.Rows.Count <= 0) Then
    MsgBox("Record does not Exists.")
    Exit Sub
End If
rpt.Refresh()
CRVInvoice.ReportSource = rpt

This Change DataBase Location to your location DPath. So that you can solve database location error. And Solve your Problem.

Thank You.

Posted 24-May-11 21:42pm

Tarun Mangukiya

Comments

raviprajapat 25-May-11 9:04am

i using database on other server.

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Accepted Answer · 2011-05-24T14:18:00

Solution 2

Here you go for solved links

Could not load file or assembly error in VS 2010 and CR[^]

Crystal Reports 2010 Beta 2 for Visual Studio Runtime Error[^]

Posted 24-May-11 14:18pm

thatraja

Comments

raviprajapat 25-May-11 9:03am

thanks

aviatcogni · Accepted Answer · 2011-10-30T20:53:00

Solution 4

Try adding the following section to your config file and it should resolve the issue.

HTML

<startup uselegacyv2runtimeactivationpolicy="true">
  <supportedruntime version="v4.0" />
</startup>

Posted 30-Oct-11 20:53pm

aviatcogni

Updated 30-Oct-11 21:11pm

v3

Comments

Sanket Khadke 28-Aug-15 5:32am

Perfect..:)

connect ashish yadav 19-Apr-17 11:39am

Works for me.
Thanks.

Crystel Report Error in VS2010

5 solutions

Solution 2

Solution 4

Solution 5

Solution 1

Solution 3

Add your solution here

Preview 0

Crystel Report Error in VS2010

5 solutions

Solution 2

Solution 4

Solution 5

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us