Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Manager9.41

Develop > Operational Reports Guide > Create and Edit Your Own Reports > Important Crystal Report Notes > Joining Multiple Tables

Joining Multiple Tables

You can combine the data from multiple tables into a single report. For example, you might want to write a report that displays the details of all open incident records, and also the contact information of the contacts who reported the incidents. The probsummarym1 table contains all the incident details, but contains only the name and phone number of the contact. Additional information about the contact is in the contactsm1 table. A join between the two tables allows you to create a report containing information about the records from probsummarym1 and the detailed contact information from contactsm1 in a single report.

Send Help Center feedback