Contact US

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.

Students Click Here

Business Objects: Crystal Reports 2 Data Access FAQ

Repository (CR9)

How to change an SQL command in the repository (CR9) by Thadeus
Posted: 12 Jun 03

OK, it seems a bit cumbersome, but this is how you do it:

Rule One: You cannot change any SQL command that is currently connected to the repository... I'm guessing they feel that this helps keep it safe

A: So, add the command to your report, in the DB Expert.
B: Highlight the command in the right hand window of the DB Expert and right click on it.
C: Choose to Disconnect from Repository
D: Right click on the command again and Edit Command should now be an available choice.
E: Make changes to the SQL, and be sure to check the Add to Repository checkbox in the lower left corner if you wish for this to be added back into the repository.

Rule Two: (My two cents) I would always add the commands to the Repository, even though you don't have to.  I have encountered issues with editing the command later (after multiple saves, etc) when the command was never added to the Repository.

When adding edited commands to the repository, and if there is no user-level security on the Repository DB, then you are able to save the command with the same name as the unedited version.

Back to Business Objects: Crystal Reports 2 Data Access FAQ Index
Back to Business Objects: Crystal Reports 2 Data Access Forum

My Archive

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