Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Report database change from Access to Sql server Post Reply Post New Topic
Author Message
Pranav
Newbie
Newbie
Avatar

Joined: 14 Jul 2007
Location: India
Online Status: Offline
Posts: 1
Quote Pranav Replybullet Topic: Report database change from Access to Sql server
    Posted: 14 Jul 2007 at 4:50am
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
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 16 Jul 2007 at 11:21am
I can't guarantee this is the problem, but do you have SmartLinking turned on?  If so, turn it off prior to setting the location of the database.  If that doesn't solve the problem, you'll probably have to manually fix the links after you set the location.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.