Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 crystal reports

Author  Topic 

thanksfor help
Posting Yak Master

106 Posts

Posted - 2006-03-06 : 19:02:21
Hi,
I am new to crystal reports.

I need to change the database connection in the reports to different sql server database and use the same report layout.

Any help is appreciated.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-03-07 : 00:43:43
Open the Report. In the menu, Database-->Set Database Location. Now select the target datasource and map it

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

thanksfor help
Posting Yak Master

106 Posts

Posted - 2006-03-07 : 16:01:49
Thanks for reviewing my question.

On doing the above, I am able to see the sql server and current database but I want to add new database to the connection or make a new new connection to this report. Since I want the same report to pick tables from a different database.
Go to Top of Page

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2006-03-07 : 19:25:49
What CR version are you using?

mk_garg
Go to Top of Page

thanksfor help
Posting Yak Master

106 Posts

Posted - 2006-03-08 : 12:03:50
crystal reports 8.5

thanks
Go to Top of Page
   

- Advertisement -