INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Data Access

CHANGING DATASOURSE OF COMMAND OBJECT. (ADD COMMAND (SQL) ). by Crystalboy1
Posted: 29 Oct 08



I was asked to map a few of the old reports to a different datasourse. (new server). When I check the reports, all of them were based on ADD COMMAND (sql statements) not tables, stored procedures or views. Those were complicated reports having grouping, formulas, conditional suppression in it, it would a big task to re-write the reports again from scratch.
I use to standard method of setting the datasourse location to the new datasource. This method works fine for Views, Stored procedures, tables not for (add command) command objects.
I tried many different methods but never succeeded. I ask on this website for help too, but no one replied to my Thread. I kept on trying different things and now finally I have solved the problem.
You need to close all existing instances of Crystal reports (if there are any open). Open the report in a new instance of crystal reports. Then In the database menu, go to verified database.
You will see a screen having existing Service, User ID, and password. Put the name of the new datasourse (new server) in the service text box, enter the user ID, and password and the command object will automatically be mapped to the new datasourse in a very quick way.

NOTE:- (if the report got verified directly without prompting for the username and password, means you are using an existing instance of crystal and you have to close the connection with the database of the existing instance before verifying the database)
 

Back to Business Objects: Crystal Reports 4 Other topics FAQ Index
Back to Business Objects: Crystal Reports 4 Other topics Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close