instead of having CR directly connected to the database, you can pass a Dataset to it. See
http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx>My DBA gave me Read Only access with integrated security to one of our SQL Server databases while I have been developing a few reports using Crystal Reports and Visual Basic 2005. We use Windows XP SP2.
>
>The reports have been working on my workstation, and I created a deployment project to test it out on another workstation.
>
>When I went to another workstation, logged in as myself, installed, the application, and ran it, I got a SQL Server Logon screen that I couldn't get past.
>
>I thought that my access rights and integrated security was all that I needed to have CR access the database on another workstation.
>
>I will need other users to use this reports application, so what should I, or my DBA, be doing to make sure that all my users can use this program?
>
>Thanks.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com