Sage 100

I thought I know Crystal pretty well and now I am finding I don't! I have a client that wants what appears to be a simple report but I am having problems getting it to work. They want a report that shows PO#, Job#, Required Date, Received Date and then a flag if the Received Date is greater than the Required Date. Report works great until I add Received Date. When I add that field, any PO without a Received Date falls off the report. I thought about adding the Received date to a subreport but I don't think I can make the date comparison if both dates aren't on the same report. I'm using PO_PurchaseOrderDetail and PO_ReceiptHistoryHeader. Ideas?

You can pass a variable from a subreport - this is not the world's greatest explanation of how I did it and the SAP links appear to all be broken. http://www.s-consult.com/2009/07/30/how-to-show-country-names-on-forms-using-older-mas-90-and-mas-200-versions/ Is this an equal link issue or a null value issue?

In the Report Settings did you check the Convert Database NULL to Default?

I would agree with Robert. If you convert null db fields to default, you may get ALL PO's rather than only those with a receipt.

Thank you all. I tried changing the Report Setting but that didn't work (but I'm really glad to know of the option). Then I tried Wagne's suggestion and changed the link to a left outer and that did work. Thanks again - now I can move on!