IIf in a formula field and Group

[nnaacc]

I'm using CR 8.0
I've got three tables:
buyers =* orders *= sellers
Every order has a buyer or a seller, but not always both.
I filter for a certain client - either as a buyer or seller.

I need to sort by the client order type, which is located on the buyer or seller table (depending on whether the client is the buyer or seller). I created a formula field called type, which is then used as a group name field.

It works fine when there is a buyer AND a seller but
the type returns null when there is only one - a buyer OR seller.

Here is the formula field:
IIf(
{Buyer.Client}={?Client},
{Buyer.Type},
{Seller.Type}
)

Thanks in advance for any help!

 

[MalcolmW]

This should work around the problem - you may also want to test for a null value for {Buyer.Client}.
If {Buyer.Client}={?Client} then
(
If Not IsNull({Buyer.Type}) then
{Buyer.Type}
Else
"Null Buyer"
)
Else
(
If Not IsNull({Seller.Type}) then
{Seller.Type}
Else
"Null Seller"
)
Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[nnaacc]

Thank you Malcolm!

It works!

After a few months of use, I've found Crystal Reports to be a terrific program, and this forum has been VERY useful as I learn more. Thanks to everyone for the posts.