Linking Excel Spreadsheet & Nulls

[chrisppppp]

Crystal XI

Hi, i've got a report and i'll like to link in an excel spreadsheet. i've got a field called AccountID in the spreadsheet and i wish to link that from the policy table using AgentID field to the spreasheet using a left outer join.

My problem comes when i run the report, if the Agent ID is null then this is totally ommitted when run. Is there anyway i can link this excel spreadsheet without the null disappearing cause if it is null then i would like to add that in a count i have running? i've tried going to to report options and setting all nulls to default values but that has no change.

Cheers

 

[lbass]

Please clarify. Is the left outer join FROM the policy table TO the spreadsheet? Is the null in the spreadsheet? Do you have any selection criteria that reference the spreadsheet?

PS. You should have continued with your original post instead of starting a new one.

-LB

 

[chrisppppp]

yeah i'm sorry, didn't realise.

the left outer is going from the AgentID field in the policy table to the AccountID in the spreadsheet. The null appears in the AgentID in the policy table. I don't have any selection criteria in my select that references the spreadsheet.

 

[lbass]

I think you meant he Account IDs are linked (see your first sentence).

You need to change the join so that it leads FROM the spreadsheet TO the policy table (since that is where the null value is), and then do not reference the POLICY table in your selection formula.

-LB