Print Page | Close Window

how to set DB details from CMC in report with 2 DB

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Self-Publishing
Forum Discription: Thinking about writing your own book or already have something to sell? Let me give you advice from my experiences.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22175
Printed Date: 25 Apr 2024 at 6:45pm


Topic: how to set DB details from CMC in report with 2 DB
Posted By: Myth
Subject: how to set DB details from CMC in report with 2 DB
Date Posted: 12 Dec 2016 at 1:25am
Hi..

Can any one help me in this Topic.

I am using Crystal 2013. I have a report created with two database. One sub report from SQL source and another from Oracle.

I am able to run the report from Crystal application and get the output. But when I moved the report in CMC and tried to set Database Configuration details but it doesn't work.

Can any one tell me if I am missing something or there is another way to set this.

Thanks in advance.




Replies:
Posted By: hilfy
Date Posted: 12 Dec 2016 at 3:45am
When you set the database configuration, you have to set it for both databases. Depending on which version of Crystal Server/BOE you're using, you'll either have a list of database connections on the left or a drop-down list toward the top of the screen.

Set the information for one connection, save, then set the information for the other connection and save.

-Dell

-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics



Print Page | Close Window