PT Sterling Tulus Cemerlang
www.sterling-team.com

Whatsapp
+62-877-8655-5055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower Level 30
Jl Jend. Sudirman No. 45-46
Jakarta 12930 – Indonesia

500+ FREE Tips SAP Business One for you to Become SAP B1 Super User from Sterling Tulus Cemerlang (STEM)

How to Change Crystal Report from HANA Version to Ms SQL Version

SAP Business One Tips How to Change Crystal Report to MS SQL


There are some conditions when you only get Crystal Reports with HANA Versions Query, and later those Crystal Reports want to be used on SQL Version Query, and you don’t need to change any value or field, you just need to change Data Source Version.

These tips will help to finish convert your crystal report faster. But first, the query needs to converted first, before trying the following steps. You can convert queries using any converter tools or do it manually.
Either you are using Stored Procedure or common Query as Data Source, you need to convert Stored Procedure from HANA Version to SQL Version, or vice versa.

  1. Open the SAP Crystal Report for SAP Business One.
  2. Go to Database → select Set Datasource Location.

    SAP Business One Tips - How to Change Crystal Report from HANA Version to SQL Version

    SAP Business One Tips – How to Change Crystal Report from HANA Version to SQL Version

  3. Choose Command on Current Data Source box, and in Replace with: choose Add Command  → press Update.

    SAP Business One Tips - How to Change Crystal Report from HANA Version to SQL Version

    SAP Business One Tips – How to Change Crystal Report from HANA Version to SQL Version

  4. Put your store procedure or query in the SQL Query box as the picture below. Don’t forget to re-create the parameter needed on this report or form, they will not re-create themselves.

    SAP Business One Tips - How to Change Crystal Report from HANA Version to SQL Version

    SAP Business One Tips – How to Change Crystal Report from HANA Version to SQL Version

  5. Then press OK, and if there is no error on your query or Stored Procedure, it will proceed to the next windows.
  6. Input the parameter to proceed to the next step as the picture below, and if there is no error, proceed to the next step.

    SAP Business One Tips - How to Change Crystal Report from HANA Version to SQL Version

    SAP Business One Tips – How to Change Crystal Report from HANA Version to SQL Version

  7. Press Print Preview or you can press shortcut F5 to check whether your conversion attempt is successful or not.

    SAP Business One Tips - How to Change Crystal Report from HANA Version to SQL Version

    SAP Business One Tips – How to Change Crystal Report from HANA Version to SQL Version

If there are no errors, then your attempt is successful. But if there is an error please check again the query and parameter you try to convert.

Also read:

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , , , , ,