• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

Crystal Reports - Grouping Error

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"
0
rporter45
Asked:
rporter45
1 Solution
 
mlmccCommented:
If they don't have a CnCnstncy_1.CnCnstncy_1_CodeLong value, it is probably NULL.  Crystal stops execution when a NULL is found and is being used in a comparison.

3 ways to solve this

1.  In some versions of Crystal, you can set the formula to USE DEFAULT FOR NULL.
    There is a drop down box that has the options.  The default value is EXCEPTION FOR NULL

2.  Change the options setting to convert NULL values to default.  That could mess up other formulas or cause other problems.

3.  Trap for the NULL value in your formula

If IsNull({CnCnstncy_1.CnCnstncy_1_CodeLong}) then
(
    if {CnBio.CnBio_Key_Indicator} = "O" then "Corporation/Foundation"
    else if {CnBio.CnBio_Key_Indicator} = "I" then "Major Gifts - Individuals"
)
else 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"

mlmcc
0
 
rporter45Author Commented:
Crazy stuff! Worked like a charm!  Thank you very much!

Have a great day,
Colleen Slater
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now