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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing null values in Crystal Reports 10

Status
Not open for further replies.

agreen10

IS-IT--Management
Oct 20, 2005
70
US
If you have three tables: I want all the data from table a and b and matching data from table c only that table c contains nulls or blanks. How can I join these tables to work.
 
Table relationships require more information than "data from table a nd b.

And what would matching data from C mean if they are null, do you mean that you want the nulls from A and B, because if they match they'll all be nulls, right?

GEnerally people will post example data to aiid in postings.

It sounds like you want to join A to B, then a left outer to C, and in the report->edit selection formula->record, palce:

isnull(c.field)
or
c.field = ""

Hard to say exactly, try taking a few moments to think through your post and supply sufficient information in the future.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top