Hi,
I am trying to link tables thru two different databases(Visual Fox Pro), using crystal reports 8.0, but whenever I try doing it thru DSN's it doesnt seems to recognize the link or relation and doesn't give the required output. Then I tried using ADO's then its giving me a cartesian product for the output, rightnow I am trying to use OLE DB setup, which is relating properly but is very slow as it takes a long time to retrieve the records.
Can anyone suggest me a better way to access the database records.
Thanks
Jack
I am trying to link tables thru two different databases(Visual Fox Pro), using crystal reports 8.0, but whenever I try doing it thru DSN's it doesnt seems to recognize the link or relation and doesn't give the required output. Then I tried using ADO's then its giving me a cartesian product for the output, rightnow I am trying to use OLE DB setup, which is relating properly but is very slow as it takes a long time to retrieve the records.
Can anyone suggest me a better way to access the database records.
Thanks
Jack