Records missing on report 1

[phartman]

I have 3 files a customer file, an invoice file, and a ship to address file. Not all invoices or customers have a ship to record, only if it was shipped to a different location than the customer address.
I am trying to do a sales tax report, which is based on destination state. I have a formula to determine the taxstate: IIF ({AD.AD_STATE}=" ",
{CU.CU_STATE} ,
{AD.AD_STATE} )

THis formula gives me the ship to state if there is one, but if there is not a ship to address, I do not get the invoice record at all. If I take the taxstate off of the report I get all invoices, when I put it on I only get the invoices that have a ship to address.

I am using Ver. 9 and oracle database.
Any suggestions?

Thanks

 

[synapsevampire]

Create a Left Outer join from the customer to the ship to address table (Database->Visual Linking Expert->select the link between the tables and select Link Options->Change to Left Outer).

This suggestion makes a lot of assumptions that you haven't shared, but hopefully it will work.

-k