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?