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

Crystal Report SAP BUSINESS ONE HANA Special Parameter for Multiple Dynamic Database

Crystal Report SAP BUSINESS ONE HANA Special Parameter for Multiple Dynamic Database - SAP Business One Tips
SHARE ON

As far as we know, SQL Query for Crystal Report in SAP BUSINESS ONE HANA must have Database variable as a prefix to procedure name. Needed to be written on every procedure, table or variable, really take times and patient. Off course, if multiple database is used, the database name must be defined for every parts of query needed.

To shorten the consumed time this is one of the tips, you need to check for.

We need to create new Special Parameter, called Schema@ as the picture below ( case sensitive ).

 

SAP Business One Indonesia Partner /rptspecial-formula-multiple-db1

And can be called as simple as example on picture below.

SAP Business One Indonesia Partner/rptspecial-formula-multiple-db2

With this special Parameter aid, you can save your time to create report for each database, all you need one .rpt file for all database.

Hope this article will help.

Copyright © PT Sterling Tulus Cemerlang – 2016

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

, , ,