PT Sterling Tulus Cemerlang
www.sterling-team.com

Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

400+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

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

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


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.

 

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

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

, , , , , ,