Skip to Content
0
Jun 09, 2020 at 07:45 AM

Changing SAP Crystal reports datasource dynamically

685 Views

S c e n a r i o

I use SBO SAP cloud with HANA DB. I referred to the document attached when I create reports in my tenants/companies.

https://help.sap.com/doc/011000358700001094092013e/9.2/en-US/B1H_HT_SetUpDSForCRL.pdf

I have reports for one company which are ready from the development perspective. I have to distribute them in 12 new companies. I want just to replace the data source with some new one. The structure in the reports should stay the same.

Unfortunately when I do that, I will lose the table schema and all formulas which are predefined in my first version of the reports. How can I avoid this? I have to recreate a serious part of each report over and over again.

The main question is:
How can I change the source of a Crystal report without breaking the report?

Additionally I have the same issue when I create .gep files via Electronic File Manager because they are based on the Crystal reports mentioned upper. I need to create .gep file for each reports I have already created.

I have 4 reports for the first company. The result will be 52 reports for all 13 companies and 52 .gep files corresponding to them.

Please tell me what the workaround is.

E x p e c t e d r e s u l t

Crystal report datasource can be changed without breaking report

Create gep file no matter what the datasource is which can be transferred across multiple tenants

A c t u a l r e s u l t

I need to create 52 reports and 52 .gep files.