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.


Multiple Db Instances for Crystal Enterprise v10 end-users

Multiple Db Instances for Crystal Enterprise v10 end-users

I have been trying get our Crystal Enterprise v10 to allow end users the choice of which Banner Db instance to run the report on. Currently the end user run the reports and they go against our production database. We would like to be able to give them a choice. And if we can't is there away to setup the Crystal Enterprise v10 and all the reports with a second Banner Db instance? We are currently on Crystal Enterprise 10 and have purchased version 11. I appreciate any help you can give me or point to me the direction to go.

RE: Multiple Db Instances for Crystal Enterprise v10 end-users

From within CE you can't change the database based on a user selection.  You would have to publish a second copy of each report that needs this and point it to the other database.  The user would then select the report that goes to the database they want to run from.  This is true no matter which version of CE you're using.


A computer only does what you actually told it to do - not what you thought you told it to do.

RE: Multiple Db Instances for Crystal Enterprise v10 end-users

Don't forget you can use dynamic data connections to accomplish this, although I don't remember if the Business View Manager existed in version 10.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


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