Need to return Null value

[The8thWonderJS]

Hello, I have a report that pulls information on two people. I need for the report to pull infor on both people because at the beggining of the report there is a chart dealingwith stats from both people. However in the meat of the report I want to sho only information from one person. I have come up tih this:

if {HPD_HelpDesk.Assigned_To_Individual_} = "Johnson, Jeremy L" then "Jeremy Stivers" else {HPD_HelpDesk.Assigned_To_Individual_} = null

The problem is that null is not recognized. Crytal wants a number there. I tried " " but it just leaves a blank spot. Any ideas?

 

[synapsevampire]

A formula won't readily return a null.

Not sure why you need to return a null, but this will work:

Create another formula containing nothing in it.

Adjust your formula to:

if {HPD_HelpDesk.Assigned_To_Individual_} = "Johnson, Jeremy L" then
"Jeremy Stivers"
else
{@MyNullFormula} = null

-k

 

[synapsevampire]

Sorry, that should hjave been:

If {HPD_HelpDesk.Assigned_To_Individual_} = "Johnson, Jeremy L" then
"Jeremy Stivers"
else
{@MyNullFormula}

-k