SAP Knowledge Base Article - Public

1712745 - How to suppress a field value which will be not equal to “particular text” and count of the group is one

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

  1. Create a sample report and create a group header one and two.
  2. The field value will be in the group header two.
  3. 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

  1.  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

  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