×
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!
  • Students Click Here

*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

Jobs

Set crystal reports Connection to Audit DB

Set crystal reports Connection to Audit DB

Set crystal reports Connection to Audit DB

(OP)
Hi,

I wanted to know how can i set the datasource of all those crystal reports to the Audit database in CMS ?

I went to Datasource location under one of the reports properties but i cannot specify the DB as it doesnt let me type into it. It says Default Universe designer etc...

But then how do i point the complete set to work with my Auditing database.

I was after a report on which Report takes the most time to run and is the biggest report ?

Can anyone advise plese...

Using Oracle 10.2.0 and BOXI 3.1

please advise

regards

RE: Set crystal reports Connection to Audit DB

You need to open the universe named "Activity" in the Designer application.  You then change the connection in the universe to point to your audit database.  Save, export, and you should be good to go.  This will change the connection for all of the reports that connect to the universe.

-Dell

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

RE: Set crystal reports Connection to Audit DB

(OP)
Hello ppls,

I am doing audit reports at the moment. So i reset the connections of Activity universe found from Samples directory of BOE pointing to my Oracle DB.

Exported that to CMS and then tried to view the crystal reports but in vain.

However if I try to view some data through WebI I can see data being populated.

But i keep getting error as Failed Connection for xxxxxx.rpt when i try to view the reports in InfoView or even through CMS.

Do i need to change the database configuration as by default it says Universe designer and username being "sa". Rest all fields are blank. But I guess i cannot update each and every report like that under Audit folder.

so please suggest your point of view in solving this..

regards

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