Nulls - Linking Excel Spreadsheet

[chrisppppp]

Crystal XI

Hi i've created a report and would like to link an excel spreadsheet in, so i've linked it in from AgentID in the Policy table to AccountID in the Inter table (the excel spreadsheet) using a left outer join.

Now i've create a formula which says:

if isnull ({tblPolicy.AgentID}) then "N" else
if {tblPolicy.AgentID} = "" then "N" else
if {tblPolicy.AgentID} = {Sheet1_.AccountID} then "Y" else "N"

However when i run my report it seems to totally ignore the nulls in {tblPolicy.AgentID} and not show them at all. Is there anyway i can link this spreasheet differently so it shows the nulls, or a better way or creating my formula so that it prints the nulls?

 

[Madawc]

If A is linked to B by a left-outer, but then you test on B in your selection, the link will fail unless nulls are allowed for.

I think you have something like that on the link. The formula seems OK.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[lbass]

If you want to test the Policy fields for nulls, the left outer join should be FROM Sheet1 TO the Policy table, with no selection criteria on fields from the Policy table.

-LB