Difference between revisions of "Using Sounds Like Criteria in Reports"

Revision as of 08:05, 30 April 2013

Click here to watch a video on SmartSimple's integrated reporting subsystem.

You can use sounds like criteria within a report to find values that are similar phonetically to the value entered. This uses the soundex phonetic algorithm feature.

• In the Calculated Field you should enter:

soundex([this])

• And in the Criteria:

=soundex(???)

The column with this syntax is not normally displayed in the report, as it will display the soundex phonetic representation of the value rather than the word.

Note:

• The Soundex function is intended to work well with strings that are in the English language only. Strings in other languages may not produce reliable results.
• Soundex may not provide consistent results with strings that use multi-byte character sets, including UTF-8.

Using Wildcard Criteria in Reports

Specifying Multiple Criteria in Reports