I am using crystal reports 11 with a btreive connection to accounting software data.
I create a new blank report and create a betreive connection to my ddf files. I then select the two tables I wish to work with one being "inventory" and the second being "MultiStore Tr". I link the tables via a common "itemcode" field.
Now I can see these tables listed under database feilds in the field explorer. The problem lies when I select a field from each of the two tables and then run the report. Nothing is displayed exept the field names, but no data. If I just use fields from one table then it all works ok but as soon as I add in another field from the second table then the report does not display any information.
I have tried this same report in version 9 of crystal and it all seems to work fine. Can anyone please suggest why this is happening and how to resolve it.