Well, I found it! On the Business Objects web site, of all things, KB article c2016958. It works for version XI, also. You must be logged in to both databases.
1. Open a report with a command object.
2. Go the 'Database' menu and click 'Set Datasource Location'.
3. In the 'Set Datasource...
I have a CRXI report with a datasource that is an ODBC connection to a MS SQL Server 2000 database. I use a single table and a SQL command object from the ODBC database. I want to point the report to a different server/database that has the same structure and tables but different data. I...
After lo these many weeks, I got an answer from a delightful and helpful CR support rep. It only took a dozen e-mails back and forth before CR assigned a Rep on this side of the pond, who was able to actually TALK TO ME to resolve the problem.
In any case, I installed the most recent weekly...
Thank you. I read that, but it didn't register as something I could do with just "crystal reports" - that I would need "business objects" Told you I'm a newbie.
Now to get that server and repository installed...
Grrr. I'm not up to speed on Crystal Server - if I distribute the report to customers (who will be running off of their own databases, not mine, and who will certainly not have Crystal Server) will they get the prompt anyway?
Soooooo lame.
Apparently the solution is to use the Millet viewer...
I've been going round with CR support for a couple of days about this.
Be gentle; I'm a newbie :)
CRXI Developer edition, Server/Repository not installed (yet). ODBC DSN to MS SQL Server 2000 database. We use SQL Server login permissions vs. Windows authentication.
When I use a dynamic...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.