Crystal Reports Query Engine Error
-
I am having some difficulties trying to get my report to display properly. I have created a Crystal Report to show some information about a customer (Name, Address, Phone Number etc) and show all the transactions they have with the company. If the customer has at least one transaction everything displays fine. However if the customer doesn't have any transactions then no information is displayed at all. All the info is taken from an access database. I asked another developer and he said that i could try to change by joins to Left Joins. The closest option i have to that is a left outer join. When i tried that, compiled and ran the report i got "Query engine error" and it displays the reports file path. I have tried a few combinations of joins and it does nothing. The default join is an inner join. I have a C# form which allows the user to specify a range of Customer ID's or a range of Customer Last Names to report on. Any suggestions would be greatly appreciated. -- modified at 10:02 Monday 20th March, 2006