Search VB 2010

Showing posts with label Crystal Report. Show all posts
Showing posts with label Crystal Report. Show all posts

Thursday, July 11, 2019

VS2010 Crystal Reports dll older version vs newer version

VS2010 Crystal Reports dll older version vs newer version

The problem 

- I have Visual Studio 2010 SP1 installed on Windows 10 32 bit, I had CR4VS 13.0.2 working perfectly on both developer machine and client machine with no problems.
- I downloaded CR4VS sp16 (exe)
- I uninstalled CR4VS 13.0.2 completely
- I installed CR4VS sp16 (exe) successfully
- Now, each time I open my Visual Basic 2010 Project I notice that the old CrystalDecision dll still has the same version 13.0.2000.0, although in my C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet .... I have the new version of dll.
Crystal Reports installed in VS 2015 in Win10 32 bit

Crystal Reports 13 sp16 is installed in VS 2010 in Win10 32 bit

CrystalDescision with old version 13.0.2 is still in VS 2010 though

CrystalDecision with new version 13.0.16 is in place correctly
After searching and searching and searching for a solution and also many un-installations and installations trials, I've found the following :

Solution :

Visual Studio 2010 loads its assemblies dll from
C:\Windows.old\Windows\assembly\GAC_MSIL
not from
C:\WINDOWS\Microsoft.NET\assembly\GAC_MSIL

so I deleted the windows.old folder
"Please, carefully search for a safe method to do so", I've done the following :

Exit Visual Studio 2010 for now.

Now, If you think you might want to downgrade from Windows 10 back to the previous version, don't delete that folder. Solve your win10 problems first.
Windows 10 will automatically delete the Windows.old folder one month after you performed your upgrade. But we are in a hurry. Here's the proper way to delete the Windows.old folder:

1: Click in Windows' search field, type Cleanup, then click Disk Cleanup.
2: Click the "Clean up system files" button.
3: Wait a bit while Windows scans for files, then scroll down the list until you see "Previous Windows installation(s)."
4: Check the box next to the entry, then make sure there are no other boxes checked (unless you do indeed want to delete those items). Click OK to start the cleanup.
5: Restart

---------- Finally, I realized that :


1) There is a difference between File version and assembly version in CrystalDescision.
2) File version varies (i.e CR4VS 13.0.16 means Developer Version 13 SP16 - File version 13.0.16, but the assembly version will always be 13.0.2.2000
3) Developing and application for x86 CPU needs CR4VS (32 bit) even if you are developing on Win-xx 64 bit and vise versa. (Crystal Reports targets the CPU Arch. target not the OS build)
4) Having your Visual Studio -xx developed with Crystal Reports i.e 13.0.16, you will need Crystal Reports Redist. 13.0.16 for your client machine as well.
5) If you have more than one Visual Studio version installed side-by-side you can work with one compatible Crystal Reports installation (I.e : Visual Studio 2010 side-by-side Visual Studio 2015, you can install CR4VS 13.0.16 for both)
Update : 

According to GAC

Crystal Reports Assembly location : 

Starting with the .NET Framework 4, the default location for the global assembly cache is %windir%\Microsoft.NET\assembly (C:\WINDOWS\Microsoft.NET\assembly\GAC_MSIL). In earlier versions of the .NET Framework, the default location is %windir%\assembly. But you won't find any assemblies there because :

.Net3.5

you need the .NET Framework 3.5. Some of the code in the SDK itself requires that version of the framework even though you can compile your application to use newer frameworks.

Crystal Reports Error 1606 "Could not access network location v4.0.30319\ASP.netClientfiles\"
- I reinstalled it using the original (exe) file, not from Add\Remove control panel.

All problems solved by reinstalling CR4VS 13.0.16 using (Exe) after removing CR4VS 13.0.2.

.Net Framework 4.5.2

All .Net frame work 4.0 and up to 4.8 , uses this app.config lines (i.e: I'm creating project using .net framework 4.5.2), so my App.Config file looks something like this :

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

Sunday, June 30, 2019

VS 2015 Crystal Report 13 Update 16

Crystal Reports in Visual Studio 2015, 2017, 2019

CRforVS_13_0_24 installation

- Problem: 

After installing Crystal reports for Visual Studio 2015 service pack16 (CRforVS_13_0_16.exe), I opened Visual Studio and I could not find Crystal reports or Reports Section in Tool Box items.

According to information from SAPTo integrate SAP Crystal Reports - developer version for Microsoft Visual Studio, you must run installer executable CRforVS_13_0_24.exe file.
Running the MSI will not fully integrate Crystal Reports into VS.MSI files by definition are for runtime distribution only.
By default Windows 10 does not install the 3.5 framework, CR for VS still needs it. Select it by "Turn Windows feature on or off" and choose both options.
CR4VS2015
Visual Studio 2015 - Modify

Solution :

Reports section in VS 2015 Tool Box

Open Control Panel > Programs > Programs and Features, and select the entry for your version of Microsoft Visual Studio 2015. In our case, it was Microsoft Visual Studio Enterprise 2015.
Click the "Change" button on the top bar above the program list.
After the splash screen, a window will open. Press the "Modify" button.
Select Windows and Web Development > Microsoft SQL Server Data Tools, and check the box next to it.
Press the "Update" button on the lower-right hand side of the window.
Once the installation is complete, open your version of Visual Studio. After the new all files are loaded, Reporting functionality should done.

CRforVS last update (EXE not MSI)

Crystal Reports Serice Pack 24 (Last update) for VS 2015 (also VS 2017 and VS 2019) appears in Items Tool Box and Add new Item menu

CRforVS - Installed and working


Sunday, April 13, 2014

VB 2010 Crystal Reports Errors

Visual Basic Online Course - Crystal Reports for VB2010 Errors and Solutions

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 VB2010 Solution Explorer Panel
and Run your application again.


Error (2)
Crystal Reports Database Login box. 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 Location Error
 Solution
Add those lines to your Form_Load where the report is being loaded to adjust the Database location (Microsoft Access 2003 Database) :

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 any where 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.

Saturday, January 19, 2013

Visual Basic Online Course Download and Install SAP Crystal Report for VS 2010

SAP Crystal Reports for Visual Studio 2010
Downloading and Installation Guide

Crystal Reports for Visual Studio 2010
Crystal Reports for Visual Studio 2010 - Download and Installation Guide

  Downloading Crystal Reports 2010 for VB 2010

Crystal Reports history briefly:
It was first released in 1991 by the Cunningham Group under titled (Quick Reports), then another version came up by (Seagate Software) in 1994 and that was until version 3.0, then automatically rebranded to a new product called (Crystal Decision) from version 4.0 to version 9.0 which acquired in 2003 by a company called (Business Objects) and they produced version 10.x, 11.x, 12.x until 2008. SAP acquired the application and produced (SAP Crsytal Reports 14) in 2011.
Downloaing the right Crystal Reports version/release for your VB 2010 steps :
1) Navigate to the SAP Crystal Reports 2010 download page and click on [ Start your free download or From here ].
Please note: To integrate "SAP Crystal Reports, developer version for Microsoft Visual Studio" into VS 2010 or 2012, you must run the Install Executable. Running the MSI will not fully integrate Crystal Reports into VS. MSI files by definition are for run-time distribution only.
SAP Downloading Page
Downloading Crystal Reports 2010 for VB 2010
Starting 2011: This is the new download page
2) You will be sent to the pick up page where you need to choose which installation file suits you better, I took the SAP Crystal Reports, version for Visual Studio 2010 - Standard that installs the software into the Visual Studio IDE, (288 MGB Version) for WinXpSp 2 or 3 [ X86 Proccessor 32 Bit ]
SAP Crystal Reports download, install for vb 2010
Downloading the correct Crystal Reports version for VB 2010
3) You will notice that your downloading started.....
After finished downloading, the installation proccess with begin and here is whar the download file called (CRforVS_13_0_3_2.exe)
Download Crystal Reports for VS 2010
Downloading Crystal Reports 2010

Installation Crystal Reports 2010 for VB 2010

1) Make sure you close the visual studio 2010. Double-Click on the [ CRforVS_13_0_3_2.exe ] to launch Desfault extracter [ ISO or WinRar ] . After finishing it loads the setup screen.
Install Crystal Reports 2010 Step by step with photos
Installation guide for Crystal Reports 2010 for VB 2010
4) There is a [ Choose Language Screen ] then you will find yourself in the [ Calculating Space Required Screen ] then the [ Agreement Screen ], if you accept then click [ Next ].
5) The [ Start Installation ] screen, click [ Next ] whenevr you are ready.
Crystal Reports Installation Guide for VB 2010
Installing SAP Crystal Reports 2010
6) Installation proccessing screen, just set back while installation copying new files.
SAP installation step by step - 4
Crsytal Reports for VS 2010 installation guide
7) Congratulations, you're done with installation. Click [ Finish ]. Although sometimes the installation progress takes much time than what is expected depending on the speed of your computer.
Installation Guide Crystal Reports 2010 for VS 2010
SAP Crystal Reports installed successfully on your Windows.

Embed Crystal Reports into Visual Basic 2010 .... Read more

Here are some online Visual Basic lessons and courses :

Visual Basic Courses - Share