The Algorithm Blog

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 →

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

Recent Posts