VB .Net 2010 WinForm Crystal Reports Errors

Crystal Reports for VS 2010 Errors and Solutions

Crystal Reports Erros

Error (1)
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. how can solve this error in windows application 
 Solution
Add those lines to your App.Config file located in your VB 2010 Solution Explorer Panel
and Run your application again.
Note : Different usages , for example .Net Framework 4.0 and .Net Framework 4.6.2


Error (2)
Crystal Reports Database Logon prompt. Some time Crystal Reports run perfectly on your machine (Developer Machine) but after deploying it and install it on another Machine, it gives you an error like this :
VB2010 Crystal Reports Database Logon Error
VB2010 Crystal Reports Database Logon Error
 Solution
Add those lines to your Form_Load where the report is being loaded to adjust the Database location (Microsoft Access 2003 Database) :
Note : If you designed your Crystal Reports without adding any tables in the Design-time, you will get an Error "The report has no tables". Also, if you added more than one table to your Crystal Report in the Design time, you will get 'Database Login Prompt

Error (3)
Crystal Reports 2010 doesn't insert pictures manually. When you try to insert a photo into the Crystal Reports 2010 it doesn't take any action. Inserting pictures in Crystal Reports 2010 doesn't work.
Crystal Reports 2010 is not inserting images in the report
Crystal Reports 2010 is not inserting images in the report
 Solution
I've tried many sites and many solutions but I've never figured out the error pattern, or why does Crystal Reports not letting me insert any photo of any kind (JPEG, JPG, PNG) or resolutions. But I landed on this solution and it is working fine with me, and it seems the only solution I've now :

  1. Right-click on the report while in the design
  2. Choose Insert, then choose Picture
  3. Single Left-click the on the photo you wish to insert
  4. Click Open, you will notice the image box appears on the report
  5. Place the Image box anywhere on the report and you will see it there.
- I used to double-click the image in the Dialog Box where I choose the Image but that did not work with me, now when I use 'Open', it is working 'Silly'

Error (4)
Crystal Reports 2010 Logon failed for Microsoft Access 2003/2007/2010 Protected Database with password.
This happens when we try to connect the Crystal Report with MS-Access Database in VB 2010 using the code (Programmatically).
Note that it won't happen we connect the Crystal Report with access protected database using the wizard, we just use the (Jet Database Password) field instead of (Database Password) field to provide the report with your Database Password.
VB 2010 Crystal Report MS-Access Password Protected Database
 But, to do this programmatically using code in VB 2010, you notice you always get "Logon Failed" Error message, using something like this :

And you get this error message :

 Solution
After many trials and tests, I've found out the only solution for this problem is to connect dynamically to Crystal Reports in VB 2010 using code is through the DataSet and DataTable Objects, here is the code to accomplish this :

Here is a full example on :
- Connecting protected MS-Access 2007 database with VB 2010
- Insert Data into Database fields
- Delete Data from Database Table
- Connect Crystal Report with VB 2010 and MS-Access protected Database Programmatically
- Update Crystal report without problems when updating MS-Access protected Database.

Error (5)
Crystal Reports SP21 Runtime on client's machine [Win7 64] caused AppCrash  Fault Module : cslibu-3-0.dll.

Solution
DO NOT LEAVE BLANKS IN THE %APPFOLDER% INSTALLATION FOLDER in OF YOUR WinForm Application. [I.e: C:\Program Files\My Installation Folder\] causes an Error 'AppCrash', to solve it , I changed the name of the installation folder [C:\Program Files\My_Installation_Folder\].


Best Practice : Connect Crystal Reports With Microsoft Access Database 2016 in WinForm Application Project VS 2015, .Net FrameWork 4.5.2 Programmatically.

Visual Basic .Net - Free POS System Project Source Code

Popular posts from this blog

Visual Basic Online Courses DataGridView Add Edit Delete

VB .NET WebView2 WinForms tips

VB .NET Google Drive Api Source Code Example

Visual Basic 2010 Working With DataBase Full Project Example

DAO in VB .NET MS ACCESS Database

VB NET Check internet connection