Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying information if table is empty 1

Status
Not open for further replies.

rewob65

Technical User
Nov 13, 2004
110
GB
I have lined two tables exmaple below

Table 1 Table 2

1 John 1 John 7
2 Jane 3 Claire 9
3 Claire
4 Sarah

I would like to return

John 7
Jane 0
Claire 9
Sarah 0

While the 0 can be blank I still want to return the name, and do caluclations on the number. i use Crystal 8.5.

Thanks
 
Assuming link is from Table1 -> Table2 make it a Left Outer Join ..(Right-Click on the Link and choose Left Outer)

That way, every record from Table1 will be returned even if no matching record exists in Table2.

To Insure Zero and not blank ( assuming field is a Number type), check the 'Convert NULL values to Default' choice in 'File..Report Options' while you have the report open in CR.




[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top