Solution : There is no issue in SAP or crystal report; This system, user permission issue. Don't belive me, try to open the SAP B1 Clinet > Run as administrator and try to preview the same error layout, it will open perfectly.
[Solved/Solution] Invalid file path - Preview Crystal report in SAP Business one
Solution : There is no issue in SAP or crystal report; This system, user permission issue. Don't belive me, try to open the SAP B1 Clinet > Run as administrator and try to preview the same error layout, it will open perfectly.
[Solved/Solution] Error while connecting to Crystal Runtime; Check the Installation
Error while connecting crystal report runtime, is common which we can see while previewing a layout in the SAP business environment.
The error occurs because there is a runtime is installed with the higher version in your system. there are multiple solutions you can find in Google and SAP SCN like installing SAP crystal report runtime
[Solved/Solution] Error with libOCAHelperw-5-0.dll when viewing a Crystal Reports report in SAP Business One
SAP Business One 9.3 PL06 + and trying to view a Crystal Reports report. I get this error:
The procedure entry point ??0DHKeyAgree@BCM400@@QAE@II@Z could not be located in the dynamic link library C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\libOCAHelperw-5-0.dll
Consider that the specified DLL does exist.
This occurs with any report, both made with my Crystal Reports for SAP Business One 14.2.5.2618 or other versions.
It happens just on one machine, while the report works on the others.
SOLUTION :
Close SAP Business One, Delete this file libOCAHelperw-5-0.dll, open SAP B1.
This Work for me. Lets check and revert me.
Add QR Code in Crystal Report - Method 2 - SAP B1 Patch
There is an Option other than SAP Patch - Method 1(Click Here)
Or the Below SAP 10 PL02 Patch method
QR codes became popular also outside the automotive industry, and used in applications to include product tracking, item identification, time tracking, document management, and general marketing.
You just have to scan it. But, before you scan it, you have to generate it… for that, SAP Business One introduces new functionality allowing you to assign QR Codes to marketing documents. Enter all relevant values in the General Settings > QR Codes tab:
In the marketing documents, a new field is added in the Accounting tab, where you can either enter text or use formatted search for generating the required value:
Add QR Code in Crystal Report - Method 1 (Need to Buy the DLL)
There is patch available in SAP B1 10, which have in-build solution for this process. You can check this HERE (Method 2).
The below method is used for SAP B1 9.3,9.2 all patches. This is a paid method, Client need to buy the required DLL for this method.
Please check the website : https://www.morovia.com/
After installing the above link software you can follow the below 5 steps :
1. Open the Crystal Report with all the Relevant data and Design.
2. Create a formula Filed and Past the below code
// Crystal Reports impose a constraint on UFL string length: max 255 characters.
// To get around this limit, use the code below
// This workaround requires Crystal Report Version >= 9
StringVar DataToEncode := {BarcodeHD_DTL};
StringVar CompleteBarcodeString:="";
NumberVar i:=0;
NumberVar Segments:=
QRCodeEncodeSet(DataToEncode, 0, 0);
For i:=0 to Segments Do
(
CompleteBarcodeString := CompleteBarcodeString +
QRCodeEncodeGet(i);
);
CompleteBarcodeString
3. Set you filed by replacing BarcodeHD_DTL
