Symptom
Suppress a field value which will not be equal to "particular text" and count of the group is equal to One
Environment
- Crystal report 2008
-
Crystal report 2011
Reproducing the Issue
- Create a sample report and create a group header one and two.
- The field value will be in the group header two.
- Have to suppress the group one and two if the field value is not equal to "particular text" and the count of the group is equal to one.
Resolution
- Write the following formula in the section expert of group header 1 and group header 2.
{Field in Group header 2}<>"Paricular text" and distinctcount({group2 field },{group1 field})=1
-
The groups will get suppressed if the text of the field in group 2 is not "particular text" and if the field count in that group is 1.
Keywords
suppress, particular text in the report, hide text in the report, suppress if count is one, text filed suppress. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
SAP Crystal Reports all versions
SAP Knowledge Base Article - Public