Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Set Database Location Problem Post Reply Post New Topic
Author Message
danasegarane
Newbie
Newbie
Avatar

Joined: 14 May 2007
Location: India
Online Status: Offline
Posts: 10
Quote danasegarane Replybullet Topic: Set Database Location Problem
    Posted: 11 Nov 2008 at 1:03am
Hi Team,
        I am using crystal report 9. And I have a huge set of reports and sub reports. I have developed my application and now i am going to move it to live. Now I face the problem of setting location for the reports. If set the location by using the root element it is not setting the location for all the reports. It just set the first report and leaves others . Now i have to open each and every record and set the location. Is there any other method to set the location at whole ?
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 11 Nov 2008 at 2:44am
Hi
 
Open the report in Crystal Client 9 then Select Menu Database -->Set Datasource Location
In Replace With Box Select your new Database Location
Highlight the Current Data Source and Replace with DataSource and Click Update.
Do the same for Subreports.
 
Cheers
Rahul
IP IP Logged
danasegarane
Newbie
Newbie
Avatar

Joined: 14 May 2007
Location: India
Online Status: Offline
Posts: 10
Quote danasegarane Replybullet Posted: 11 Nov 2008 at 3:10am
Thanks for the reply Rahul . The problem is that the report is connecting to number of talbles(eg 6),then i have to do this for all the tables listed. How can I minimize this effort ?
IP IP Logged
danasegarane
Newbie
Newbie
Avatar

Joined: 14 May 2007
Location: India
Online Status: Offline
Posts: 10
Quote danasegarane Replybullet Posted: 11 Nov 2008 at 3:17am
See the image.

http://img91.imageshack.us/img91/8693/imageoh6.jpg

How can set at it one. Only the Database Differs. The table name remains same........
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 11 Nov 2008 at 3:30am
Select the
Current DatabaseName Highlight
Replace with DatabaseName Highlight
Click Update
 
 
Cheers
Rahul
IP IP Logged
danasegarane
Newbie
Newbie
Avatar

Joined: 14 May 2007
Location: India
Online Status: Offline
Posts: 10
Quote danasegarane Replybullet Posted: 11 Nov 2008 at 3:54am
I am not able to get you. Could you please give a screen shot ?
IP IP Logged
danasegarane
Newbie
Newbie
Avatar

Joined: 14 May 2007
Location: India
Online Status: Offline
Posts: 10
Quote danasegarane Replybullet Posted: 11 Nov 2008 at 6:22am
Any one ?
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.027 seconds.