Skip to Content
Former Member
Jan 22, 2015 at 03:11 PM

CR 2011 - Bus. Object/CMS using two data sources


I hope I am posting this in the correct area.

I have a report that I created that pulls data from two data sources - an ODBC (SQL) database and data from Sales Force.

The report has three parts - the main report and two sub-reports. The main and sub-report 1 pull data from the SQL database. The 2nd sub-report pulls data from Sales Force.

If I run the report in Crystal, the report works fine. I do have to enter two separate passwords, which is not a big deal.

What I cannot get to work is to upload this report to our Business Objects / CMS site to have the report auto-deliver to a distro list. I suspect because I can only enter a single database / password combo for the main database source and no place to enter the password for Sales Force.

Is what I am trying to do even possible?