Using the Command Line Variable Replacement

Logicity Pro has the unique ability to process command line replacements, a feature that will thrill all of you who are systems integrators. If your software supports VB scripting, or any other method of obtaining information about the data currently on the screen, then you can use command-line variable replacement to call your custom Crystal Report.

Here are the steps to use command line replacements:

1. Obtain a copy of Logicity Pro for each system that needs to use this feature.

2. Choose a report file that has a parameter that you'd like to fill in from the command line. For this example I am going to say I have a sales order report that has a parameter for Sales Order ID.

3. Develop a Logicity Solution for this report and specify the parameter with a value of %SALES_ORDER%. This value can be anything you choose as long as it has no spaces and is enclosed in percent signs.

4. Now test the command line replacements from a command line first:
   
   C:>"C:Program FilesSaberLogicLogicityLogicity Desktop.exe" "C:Test.rrd" SALES_ORDER=CO-12345
   
   Where C:Test.rrd is the path to your RRD file and CO-12345 is the value you want to substitute in the RRD for %SALES_ORDER%.

5. Using this methodology, integrations with systems is vastly simplified. Any system supporting some sort of VBA macro layer can use code similar to the following to integrate with on-screen fields:
   
   Dim wshShell, logicity
   Set wshShell = CreateObject ("WSCript.shell")
   logicity = """C:Program FilesSaberLogicLogicityLogicity Desktop.exe"""
   solution = """V:Test.rrd"""
   replacements = """" _
   & "ORDER_ID =" & ORDER_ID.Text
   & """"
   
   wshshell.run logicity + " " + solution + " " + replacements, 1, True

If you have any questions about the capabilities of Logicity Pro, please contact us at This e-mail address is being protected from spambots. You need JavaScript enabled to view it .

Logicity for Visual Manufacturing

In late April 2008, SaberLogic released a specialized version of Logicity for the Visual Manufacturing ERP system sold by Infor. The purpose of this release is to provide users of Visual with the ability to execute custom Crystal Reports right from within the Visual user interface. In addition, Logicity for Visual Manufacturing takes advantage of the macro functionality to pass various screen parameters directly to the Crystal Report.

Logicity for Visual can be used with any version of Visual Manufacturing that has the macro menu available. Visual version 6.5.3 is the first version to include macros for all modules. Versions prior to v6.5.3 have only a limited number of modules that allow you to take advantage of macros. The list of those modules is available here.

Logicity for Visual Manufacturing is priced at $65 for the server and $65 for each end user. A site with more than 100 users can take advantage of the $6,500 site license. In the coming months SaberLogic will be offering pre-developed Crystal Reports that will provide a 1-to-1 replacement for many of the stock Centura reports.

For more information, please contact your Visual Manufacturing reseller or SaberLogic at This e-mail address is being protected from spambots. You need JavaScript enabled to view it .

Winning Logicity Swag

Starting in August and running through the end of 2008 we will be awarding some Logicity "swag" to anyone who helps us find software bugs or suggests a new feature that we decide to implement. The only rules are that you must be the first person to report a particular bug or a feature to win the "prize".

So what exactly are these exciting prizes?

• 1st bug or feature - A shiny new Logicity coffee mug.

• 2nd bug or feature - A single complimentary Logicity Professional license

• 3rd bug or feature - $25 gift card to Starbucks. We want to make sure you have some good coffee to put into your Logicity mug.

To the person who provides the most bugs and features we will offer a 2GB iPod Shuffle as the grand prize. Watch the Logicity website for more details on the program and on how to submit your bugs and feature requests.

Our Next Issue - July/August 2008

• Logging End User Report Use

• Locking Down End-User Controls

• Ready, Set, Go!