Preview/Print of a Document (Crystal Report) not working

[Andy_SB1]

Hallo SAP B1 Community,

i have the problem that, when i want to print a Document as CrystalReport i get 3 Errors:

Invalid path for report file
Invalid path for report file
Cannot load the rpt file

If i import the Exact same report on a different SAP B1 Installation (always HANA) the Prints and Preview is working fine.
What could be the issue i am missing?
(i cleaned the tmp cached files already mutliple times) and i need the Crystal Report to print from the Web Client.

[mgregur]

Hi,

is your report based on DB tables or a command? If tables, check that you don't use any UDO/UDT which is not present in the "new database, and if using Command make sure you do not use hardcoded schema.

BR,

Matija

[Andy_SB1]

Hallo Matija,

[Andy_SB1]

Hallo Matija,

thank you for the reply. The report is based on DB tables. There are no UDO/UDT's in the report. We even tried to remove everything except the head of the report and we also tried to use the document sample from https://support.boyum-it.com/hc/en-us/articles/360004532418--Crystal-Reports-Template-files still got the same error.

Best Regards

[mgregur]

Hi Andy,

on what version are those databases? And does this happen when first printing or after a while?

There are several possibilities:

- the database you are experiencing problems with is on the latest version, and the other one is an older, using 32-bit ODBC driver (new versions do not support 32-bit but only 64-bit)

- you are using FP2111 and are experiencing issues after printing several documents (see note 3151730 - Invalid Report File Path with Crystal Reports and/or note 3307252 - Invalid Report File Path in Document Printing or Emailing for explanation)

- there are some UDFs in the system tables which are not present in the database you are having problems with

Let me know if it is any of the above.

BR,

Matija

[Andy_SB1]

Hallo Matija,

it happens every time. It also happens if i click on Advanced if i am in the Report and Layout Manager, select the report and i click on advanced.

I have installed the last 64 Bit and 32 Bit ODBC Driver.

The version i am using is 2502.

There is no UDT used in the Report itself, but there are some UDO/UDT's in the Database.

Best regards
Andy

[mgregur]

Hi Andy,

from everything you mention it seems that the report was not properly imported. You need to open it in Crystal reports, go to "Database => Set Datasource Location" and ensure you have the correct connection setup for your current database. Connection should be set up like "DRIVER={HDBODBC};SERVERNODE=your_server:30015;DATABASE=your_database".

Optional parameters for the connection string are the DB user and DB user password, but I do not recommend using them as those can cause an error if vaules change.

BR,

Matija