<div>
Crazy stuff! Worked like a charm! &nbsp;Thank you very much!<br />
<br />
Have a great day,<br />
Colleen Slater
</div>


Crazy stuff! Worked like a charm!  Thank you very much!

Have a great day,
Colleen Slater

<div>
<div class="content wysiwyg-content">
Good morning,<br />
<br />
I am not able to figure out what is going on and am seeking help with this. &nbsp;I have created a field called &quot;Grouping&quot; and in it I have identified the groups below. &nbsp;This issue lies with the last two segments of the group where I switch to using the field Key Indicator. &nbsp;This is to catch any records that do not have a segment in the group already. &nbsp;Every record has a key indicator. For some reason NO records fall into these segments when they should be.<br />
I have attached a screenshot of the grouping - any ideas are greatly appreciated!<br />
<br />
Thank you - cs<br />
<br />
If {CnCnstncy_1.CnCnstncy_1_C<wbr />odeLong} = &quot;System Board&quot; then &quot;System Board&quot;<br />
else if {CnCnstncy_1.CnCnstncy_1_C<wbr />odeLong} = &quot;Foundation Board&quot; then &quot;Foundation Board&quot;<br />
else if {CnCnstncy_1.CnCnstncy_1_C<wbr />odeLong} = &quot;Management&quot; then &quot;Administration&quot;<br />
else if {CnCnstncy_1.CnCnstncy_1_C<wbr />odeLong} = &quot;Physician&quot; then &quot;Physicians&quot;<br />
else if {CnCnstncy_1.CnCnstncy_1_C<wbr />odeLong} = &quot;Foundations&quot; then &quot;Corporation/Foundation&quot;<br />
<b>else if {CnBio.CnBio_Key_Indicator<wbr />} = &quot;O&quot; then &quot;Corporation/Foundation&quot;<br />
else if {CnBio.CnBio_Key_Indicator<wbr />} = &quot;I&quot; then &quot;Major Gifts - Individuals&quot;</b>
</div>
</div>


Good morning,

I am not able to figure out what is going on and am seeking help with this.  I have created a field called "Grouping" and in it I have identified the groups below.  This issue lies with the last two segments of the group where I switch to using the field Key Indicator.  This is to catch any records that do not have a segment in the group already.  Every record has a key indicator. For some reason NO records fall into these segments when they should be.
I have attached a screenshot of the grouping - any ideas are greatly appreciated!

Thank you - cs

If {CnCnstncy_1.CnCnstncy_1_CodeLong} = "System Board" then "System Board"
else if {CnCnstncy_1.CnCnstncy_1_CodeLong} = "Foundation Board" then "Foundation Board"
else if {CnCnstncy_1.CnCnstncy_1_CodeLong} = "Management" then "Administration"
else if {CnCnstncy_1.CnCnstncy_1_CodeLong} = "Physician" then "Physicians"
else if {CnCnstncy_1.CnCnstncy_1_CodeLong} = "Foundations" then "Corporation/Foundation"
else if {CnBio.CnBio_Key_Indicator} = "O" then "Corporation/Foundation"
else if {CnBio.CnBio_Key_Indicator} = "I" then "Major Gifts - Individuals"

Crystal Reports - Grouping Error

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.