Q: For Crystal reports experts 
Author Message
 Q: For Crystal reports experts

Dear experts:

I am having no success creating a particular report using Crystal
reports on VB4.0 for a seemingly simple task with an Access database
that has 7 tables.

What I want to do is print all the records in one table in which the
primary key field is unique amongst ALL the tables.  For example,
say you have a 'Customers' table and a 'Purchases' table.  Both tables
have a field called customerID, but one table contains customer
info (names, addresses) and the other table contains purchase info
(productID, date, amount, etc  and customerID).

I want to print the customer info for the customers who have NOT
purchased anything.  The opposite objective is easy, since Crystal
reports automatically does an 'inner join', making a list of the
customers who have purchased something.  If this was ACCESS, I would
probably do a LEFT JOIN on customerID where purchases.customerID is
null (or something to that effect) to get my desired result.

I have tried several combinations of various functions like ISNULL in
the SelectionFormula property of the Report Object, to no avail.

Any ideas?  Much appreciated.

From a Client/Server student who is currently looking for his big
break into programming (in the Boston area)

Sat, 07 Aug 1999 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Southern CA, Crystal Reports/Crystal Info expert needed, consultant

2. Southern CA, Crystal Reports/Crystal Info expert needed, consultant

3. Crystal Reports Distribution Reports Expert

4. Looking for Crystal report expert (to do report from Soffront Track bug database)

5. Crystal reports select expert can only read first 300 records from sybase

6. Crystal Reports 4.5 - Visual Linking Expert problems

7. Select Expert problem in Crystal Reports 8.5

8. Crystal reports Graph Expert Need!

9. EXPERT NEEDED: Crystal Report

10. Crystal Reports Experts (Changing Image at runtime)

11. Crystal Reports EXPERT

12. Crystal Reports 5.0/Expert Sales(G2)


Powered by phpBB® Forum Software