I'm using CrystalReports9. I have a set of report files that I need to change the existing data source location from a SQL2000 database server to a SQL2005 database server. I can change the data source location just fine if the report only uses a SQL Server stored-procedure; however, if the report uses tables or views from the SQL Server database then I have a problem.
I can set the new data source location in the CrystalReports9 designer, and it runs/previews just fine in the designer's preview. However, when I publish the report to run live/production, I get prompted to enter a username/password for the database.
Has anyone experienced this challenge? Any suggestions is much appreciated!
PS: Yeah, yeah, yeah... I know I'm using CrystalReports9 right now,.... but I am in the process of migrating to BOXI..., but I do need an interim solution.
IP Logged
