×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Records not Reported

Records not Reported

Records not Reported

(OP)
I have two tables that are 'Equal' joined. I'd like to report on all records in TABLE1 as well as all records in TABLE2. I am finding that records in TABLE2 are not reported when the linking item is not in TABLE1. In other words, if I have records 2010, 2012 and 2013 in TABLE1 and records 2010, 2011, 2012 and 2013 in TABLE2.....record 2011 in TABLE2 is not reported. What do I have to do so all records in TABLE2 are reported?

RE: Records not Reported

Us a full outer join, if this is not available in your version of Crystal use a command to bring back your data

select * from
Table1
full outer join table2 on table1.fieldPK = table2.FieldFK

Ian

RE: Records not Reported

(OP)
Thanks Ian. I suspected that would be the solution but the ways I can redo the join are not available to me in CR8.5. Visual Link join option is greyed out. 'Database > Show SQL Query' is also greyed out. My source database is Access.

RE: Records not Reported

I only used 8.5 with SQL, but you should be able to use your database expert to make the link "Left Outer".

Note that any test applied to TABLE1 will spoil this, because missing records have Nulls in their fields, and Null stops everything. Testing IsNull first should get round this.

yinyang Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP yinyang

RE: Records not Reported

PS You can use SQL with Crystal 8.5, but it's vastly awkward compaired to later versions, and I forget the details.

yinyang Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP yinyang

RE: Records not Reported

You can not use SQL with Access as Access is not true SQL database.

I am not an Access user so dont know if you can create a view in Access which does the same thing.

Failing that you might be able to create an access view which unions data into a single table.

Ian

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close