In SAP Crystal Reports XI, return records that match multiple conditions

---

<p style="">It is advisable to use functions to pass such filter conditions in CR. Also try changing the order of your condition like &minus;</p><pre class="result notranslate">({PR.cov} = &quot;A&quot; and {PR.cov}=&quot;B&quot;) or {PR.cov} = &quot;A&quot; Try using function like this: {@A}:if {PR.cov} = &quot;A&quot; then 1 else 0</pre><p style="">To create custom functions in Crystal Report, navigate to Report Menu &rarr; Formula Expert &rarr; Right Click on Custom Functions &rarr; New</p><p><img src="/assets/questions/images/101733-1513052894.png" class="fr-fic fr-dii" width="605" height="328"></p><p style="">It is advisable to use custom functions when you have multiple parameters to pass in the condition. You can also use the following when you have two string parameters &minus;</p><pre class="prettyprint notranslate">( &#39;A&#39; IN {?cov} OR {PR.cov} IN {?cov ) AND ( &#39;B&#39; IN {?cov} OR {PR.cov} IN {?cov )</pre>

• Related Questions & Answers
• Edit report generated from SAP Crystal Reports
• Displaying Records with maximum event number for each group in SAP Crystal Reports
• Hiding null values in a column in SAP Crystal Reports
• Using Filter to fetch specific data in SAP Crystal Reports
• Difference between SAP Crystal Reports and CR for Visual Studio
• In SAP Crystal Reports, removing extra white space between details sections
• Suppressing the page header till the last page in SAP Crystal Reports 2008
• In SAP Crystal Reports, Putting 2 pages of data into a single report
• Getting a carriage return of report field in SAP Crystal Report
• Find records in MongoDB that does NOT match a condition?
• Implement multiple conditions in MongoDB?
• Check if an array contains the elements that match the specified conditions in C#
• How to generate multiple reports in HTML using PowerShell?
• Replace records based on conditions in MySQL?
• SAP Crystal Report file is not opening in VS2015