how to include null records?

[Mapril]

Dear experts,

I am new and don't know how to use isNull function.

In my report, I want to show projects that assigned to 3 specific managers among 6 other staff in different positions. However, I also want to show projects that are not assigned to anyone.

So, I have:
{MA_Assigned Staff Type} = "Manager" and
{MA_Assigned Staff Name} in ["Mary", "John", "Amy"]

But, I just don't know how to use the isNull function (I think is used for including null records?). How is it look like in the formular?

Any advice will be appreciated. Thank you in advance.

MA.

 

[dgillz]

Isnull({YourField})

The null test MUST be first, before any other tests.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[Mapril]

sorry, I still don't understand how it is supposed to be
Whne I put isnull formular first, like:
isnull{MA_Assigned Staff Name} and
{MA_Assigned Staff Type} = "Manager" and
{MA_Assigned Staff Name} in ["Mary", "John", "Amy"]

it gives me a message "the remaining text does not appear to be part of the formular".

Any idea?

thanks.

 

[Turkbear]

Hi,
You need parens - IsNull is a function so your code would be:

isnull[COLOR=red]([/color]{MA_Assigned Staff Name}[COLOR=red])[/color] and 
{MA_Assigned Staff Type} = "Manager" and
{MA_Assigned Staff Name} in ["Mary", "John", "Amy"]

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Mapril]

Thank you! It helped.