Change Connection Properties of Crystal Reports XI

See more:

VB

SQL-Server

MS-Access

, +

i have an application that uses crystal report XI for reporting and now my problem is the application runs both MS Access and SQL Server right now the connection properties of the crystal report is set to MS Access so when i use Access there is no problem with previewing the report but if i want to view now in SQL Server it gives me a login form. My question is how to change the connection properties via code from MS Access Properties to SQL Server Properties.

Please i need your help, i can't manually change the connection properties because the report is being deploy now to the customer. Sorry for my Bad English i hope you understand a little bit

Any help would be appreciated.

Thank you very much

Platforms
-> VB.NET 2005
-> Crystal Reports XI
-> MS Access 2003
-> SQL Server 2005