Null Value

[rewob65]

Using crystal 8.5 I have two data sets one with the company and expected delivery day say Wednesday and another with the actual delviery say 5.10.05 (a Wednesday).

I want to return all the information for expected deliveries for Wednesday showing if one is included or not ie the actual delivery is not recorded.

When I filter on date it excludes any expected delivery if there is no actual I want both.

I can answer any queries,

 

[lupins46]

If the date might be empty why are you filtering on date and not day(Wednesday)

 

[rewob65]

I am also filtering on the day. However I also return all dates. I have overcome this by using a null decision