In Crystal Report 2011 I have problem connecting SQL Server table "Supplier" with excel file "Product_Info". I am getting cartesian product.
In excel file Product_Info I have several fields one of them is field Supplier_Number and it is number type field.
In crystal report I have table Supplier that has Supplier_Num field as text type field.
To connect this table with the excel file by those two fields I had to add “”- space in Excel field Supplier-_Numer at end of the field, so when imported in crystal it would be text type field. I did that change. Then in crystal report I made new connection : CreateNewConnection\Access./Excel(DAO) and brought excel file in.
Then I linked them and they should go as one to many or Left outer join(Suppliier.Supplier_Num To Product_Info.Supplier_Number).
In crystal I can see that in Product_Info Supplier_Numer is text type filed,Everting looks ok.
However what is happening I am getting Cartesian product between those too tables.
And how to get proper link?