

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 −</p><pre class="result notranslate">({PR.cov} = "A" and {PR.cov}="B") or {PR.cov} = "A" Try using function like this: {@A}:if {PR.cov} = "A" then 1 else 0</pre><p style="">To create custom functions in Crystal Report, navigate to Report Menu → Formula Expert → Right Click on Custom Functions → 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 −</p><pre class="prettyprint notranslate">( 'A' IN {?cov} OR {PR.cov} IN {?cov ) AND ( 'B' 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
Advertisements