I have the prepackaged version of Crystal Reports that came with Visual Studio 2003. I used this previously to create (and use!) reports based on a SQL SERVER 2005 edition.
I have since moved firms and whilst I use the same version of VS SQL server is 2008.
I can create the report, I can browse through the data (in design time) I can view all the other tables/views in my database
I use integrated security on the server which is local to my machine. My log in has the highest permisions you can get (I'm a SYSADMIN); indeed I have even tried to create a 'crystal' log in with a password to connect to the database but EVERY time I try and open the report in run time I get prompted to log onto the database.
Its almost as if the connection detials are 'forgotton' when the app is compiled
Any thoughts as to what caused this weird error?!
Thanks in Advance