How does Crystal do its record selection (1 Viewer)

wan2fly99

Registered User.
Local time
Today, 12:43
Joined
Feb 7, 2005
Messages
53
I have to tables

vendor

ap

I have linked them up in database link on a key field vendor-num and said the vendor table is an outer join

In the report in the Select Expert: I have another requirement to state that AP record the field balance <> 0

Now Does crystal first do the outer join and get all the records.

Then it goes to the Select Expert and filters out more?

I wanted all the vendor records and and only those AP records with balance not 0. If no AP records for that vendor I still wanted the vendor record

It seems if AP record with balance of 0, the associated vendor record does not get selected.


A bit confused here

Any help is appreciated
 

boblarson

Smeghead
Local time
Today, 12:43
Joined
Jan 12, 2001
Messages
32,059
Crystal Reports connects to the Access database and then the Select Expert will modify the Recordsource SQL Statement that Crystal is using for the Database "connection." If you want an outer join, you can't just set it in the relationships of the database. You would need to modify Crystal's SQL Statement or you would need to create the query in Access and then link to that from Crystal.

It has been over 5 years since I've been inside Crystal Reports so I can't tell you exactly where all of this is set. But hopefully I've given you enough of a clue to be able to find it yourself.
 

wan2fly99

Registered User.
Local time
Today, 12:43
Joined
Feb 7, 2005
Messages
53
thanks for the help was afraid of that. Will look into biulding an sql stmt have that as the record source for the crystal report then
 

kevlray

Registered User.
Local time
Today, 12:43
Joined
Apr 5, 2010
Messages
1,046
wan2fly99:

When working with Access, having Crystal Reports use an Access query should work the best. You could use the Database Expert and link tables there, but I have seen a big performance hit doing that way. I hope this helps.
 

Users who are viewing this thread

Top Bottom