The Algorithm Blog

Rick Debusk

Recent Posts

A Farewell Message from Rick DeBusk

“The moving finger writes, and having writ, moves on…” — The Rubaiyat of Omar Khayyam

Forty-five years have elapsed since I began a career in manufacturing working as an injection molding machine tender on the midnight shift. Events, education, and experiences led into a position as a manufacturing applications consultant some twenty years ago. I will be retiring from full-time consulting at Algorithm effective December 31, 2018. Barb and I plan to devote more time to family, volunteer work, and travel.

Continue Reading →

The Importance of Inventory Accuracy

For manufacturers and distributors, product availability (i.e. inventory) is the driver of almost all revenue-generating activity.  Next to fixed assets (property, equipment), inventory represents the biggest outlay of capital.

Continue Reading →

SSRS Vs. Crystal Reports — Some Key Differences

Posted on July 14, 2017 by Rick Debusk

Many companies are moving towards developing system reports in SQL Server Reporting Services (SSRS) vs. Crystal Reports. Here are some key differences between the two systems and a few compelling reasons for why this shift is happening:

Continue Reading →

Manufacturing Software: Everything You Need to Know

Employing manufacturing software can optimize and empower your employees to efficiently manage your business resources and processes.

In turn, this allows your company to focus on profit-making products and outsmarting the competition by eliminating slow production cycles, inefficient scheduling of resources, inventory excesses and shortages, and redundant data entry.

Continue Reading →

Crystal Reports Help: Using Not In Logic in Record Selection

Posted on June 12, 2013 by Rick Debusk

Record selection criteria is set in Crystal Reports in the Select Wizard. Users can build a custom record select statement using multiple criteria. By clicking on the Show Formula button, users can see the Select statement.

If an SQL query already exists, users can paste the SQL select statement into the Select Expert Formula window. Here’s an example of a SQL statement pasted into Crystal and cleaned up to conform to Crystal requirements:

Continue Reading →

How to Build a Master List of Crystal Reports

Posted on July 09, 2012 by Rick Debusk

Are you looking for a list of all currently published reports with descriptions in Crystal Reports? As you may know, hovering over a report name will show you the report descriptions but this could mean potentially hovering over hundreds of reports, which is not a very good use of your time.

The best way to build this master list is right within Crystal Reports. To do this you must have the report files stored in a folder locally.

Continue Reading →

Crystal Reports: IN and NOT IN Record Selection

Posted on June 21, 2012 by Rick Debusk

Many of Algorithm's customers use Crystal Reports as their reporting platform. It is a mature platform with a large user base and is a great tool for report writing. A customer recently ran into a syntax issue while using Crystal Reports so we wanted to share the resolution.

The proper Crystal Reports syntax for searching using the NOT IN operator is different than the IN operator.

Example for IN Syntax: 

RecordSelectionFormula = "{ERPtable.field2}in [ " & xyz & "]".

If a NOT operator is merely added to this formula (e.g. RecordSelectionFormula = "not {ERPtable.field2}  in [ " & xyz & "]" ), it fails with a boolean or string expected error message.

Example for NOT IN Syntax:

not({table.field} in ["A","B","C"]).

Continue Reading →

Subscribe to Our Blog

JOIN OUR UPCOMING WEBINARS

Algorithm hosts live webinars each month on Acumatica, BI/CPM, manufacturing/distribution, and more! Register in advance here.

Recent Posts