I know I need to move onto RDC but for now I have too many clients running
on this control and too many reports as well once I get them all up and running properly I will look into RDC but for now my only problem is passing the user ID and Password to crystal, when I set up the crystal report as a trusted connection it works fine but I would like it to use SQL server authentication for now if at all possible.

Thanks Again
Stephen J. Hunt