Can anybody Help me with this?
I am trying to convert database location of my existing crystal reports from Access to SQL Server. I have successfully exported my Access database to Sql Database with Indexes info. However when I try to change the location of the tables in my crystal report from access to SQl server, the relationships between two tables is merged to one field of destination table.
Ex.
I have two tables AccBal and Ac Master in my Report
My Relationship is Accbal.AcCode with AcMaster.AcCode and AccBal.AcSubcode with AcMaster.AcSubcode.
When I set Location of both the tables, The relationship changes to Accbal.AcCode and AccBal.AcSubcode both points to AcMaster.AcCode.
I have tried Convert Database driver from MSDAO to pdssql.dll mathod also, but result is he same.
Can anyone suggest sum database conversion tool, I have to convert approx. 200 Reports.
Thanks in Advance,
Pranav