Click to See Complete Forum and Search --> : problem with crystal report


royamarnath
July 4th, 2006, 08:18 AM
we are having a problem in crystal report...
i am trying to describe it in below.

we develop crystal report[backend oracle] in our offshore. While making reports,we provide our local database connection information [username,password,database name]. and after making those reports we send those to our onsite. but in onsite the databse parameters are diff[username,password,dbname]. and the reports use the default connection paramaters which we had given in offshore. the reports run in onsite by a batch process. so it gives error while runing the reports. the solution is to manually change the paramaters[username,password,dbname] but as the no of reports r too many thats why it is a very much tedious job.
can u provide some solution regarding this??
We have to come up with a generic migration plan for all the reports, so that the reports can be run successfully after migration to the Crystal Server.

Is there a way to store the Database connection parameters in a centralized location in Crystal Server and apply the same database parameters to all reports under a particular folder? If we get this working, then we do not have to type the database parameters for each report in Crystal Management Server.


I hope i can make understand the problem. we need a sloution regarding this.. please help me.
Thanks
Roy

sraheem
July 5th, 2006, 06:21 AM
if u r using crystal 10 or above, write ur query in command object, it will execute on any database if structure is same