Click here to Skip to main content
11,490,566 members (37,075 online)
Rate this: bad
good
Please Sign up or sign in to vote.
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
Posted 8-Aug-12 17:34pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 520
1 Andy Lanng 233
2 Sascha Lefèvre 210
3 OriginalGriff 188
4 Maciej Los 160
0 Sergey Alexandrovich Kryukov 9,713
1 OriginalGriff 8,475
2 Sascha Lefèvre 3,544
3 Maciej Los 3,106
4 Richard Deeming 2,370


Advertise | Privacy | Mobile
Web03 | 2.8.150520.1 | Last Updated 31 Oct 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100