Hello Crystal experts,
As you?ll see I am an untrained Crystal Reports novice, and I could do with some advice.
Here is a simplified example to demonstrate what I am trying to do.
Say we have a customer table containing a row for EVERY customer. It contains just 2 columns, custno and custname.
So it might contain:
We also have an info table that contains various rows for various things we know about our customers. It contains 3 columns, custno, infotype and info. A customers may have none or one or many rows in this table. It might look like this:
001 credlim 100.00
001 address 44 Oak Street
001 haircolor Blonde
002 haircolor Red
003 credlim 200.00
I want a list of all my customers showing name, and if available, address.
I can't find a way to construct the report so it will show me ALL customers in the customer table, and show the corresponding address if there is one present in the info table. If there isn?t an address just show the notation ?no address?.
Depending on what I try, I either get a list that shows every infotype for every customer, or it only shows an entry for those customers who have an address infotype.
Also, can you recommend a good online Crystal reports training tutorial that I could buy?
Thanks for your help.