Report with multiple tables problem

[oxbow123]

I would like to print a report summary for a customer.

Tables involved are :

CUSTOMER
ORDERS
INVOICES
PAYMENTS


in the header of the report I display CUSTOMER DATA (work fine)
I send only data from 1 customer through the dataset.


in Detail section I display ORDERS DATA (work fine)

to display INVOICES and PAYMENTS data I need to create 2 new section Detail but when I put field inside and run the full report it is empty !!!

Links between all table are correct I have the CustomerKey in all tables and they are linked all to Customer.

Is there a other way to do that ?

Thanks,

Sebastien.

[jbradshaw]

Unfortunately, I'm really new to Crystal Reports but I was experiencing a similar problem to what you're describing so I think I might be able to help you out. In order to get the data to display correctly (or at all), I had to change the link types. I'm not sure what will work in your case, but I changed all the links to right outer joins and it works now. If you don't know how to do this...open the visual linking expert and right click on each link that connects to the CUSTOMER table and click on "Link Options". Change the join type to right outer join. Hope this helps...it's definitely not easy to find Crystal Reports info out there.

[brucevde]

Correct me if I'm wrong but it looks like you are trying to display un-related data. Is there a logical relation between Invoices and Orders, Invoices and Payments etc.? All three have a relationship with Customers but if you are trying to return all possible data in one sql statement your report will end up with several formulas, groups, sections that just aren't neccessary.

What I usually recommend to people is to learn how to use sub-reports. Instead of trying to link all tables (which were never meant to be linked), create a subreport.

For example, your main report might display Customer and Order information. While one sub-report could display Invoice and Payment information (if there is a logical link between the two) or have a different sub-report for each.

Don't try to cram everything into the main report.

HTH