SAP Business One SDK Support

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

[Solved/Solution] Invalid file path - Preview Crystal report in SAP Business one

Getting this error message: "Invalid Report File Path" while previewing the SAP CR Layout 



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.

Check and change the permission os System user will full access to SAP and SAP related folders in C drive.

[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





Solution: Uninstall SAP B1 Client and Install it again from the Setup or from the B1_SHR folder.

This will reinstall the runtime required for the client to preview the CR Layout


 

[Solved/Solution] Error with libOCAHelperw-5-0.dll when viewing a Crystal Reports report in SAP Business One

Advertisement



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:

No alt text provided for this image

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:

No alt text provided for this image

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 

Advertisement



Create a simple report for SAP Business One 8.8


Create a simple report for SAP Business One 8.8

Crystal Reports

Crystal Reports is a business intelligence application used to design and generate reports from a wide range of data sources. Several other applications, including Microsoft Visual Studio, at one time bundled an OEM version of Crystal Reports as a general purpose reporting tool. Crystal Reports is a popular report writer, especially when Microsoft bundled it with Visual Studio versions 2003 through 2008. Microsoft discontinued this practice and later released their own competitive reporting tool, SQL Server Reporting Services (SSRS). Crystal Reports for Visual Studio 2010 is still available as add-on software.