Logon Error for Crystal Report Viewed by User When Not Included In App
I have a Visual Basic 2008 SP1 application and I'm using Crystal Reports 2008 SP0 (with FP1 + 2). I have about 50 reports using integrated security that are all "embeded resources" in the application. When I want to print one of these reports I use code like this:
And in my PrintReports routine it just creates a new instance of a form that has the report viewer control on it and passes the report over to it. This works GREAT and I can embed all my reports right into the app and call them when I need them.
Recently however I've had the need to add some custom reports that may change more often then the app changes so I need a way for users to access their reports without a new version of the app being pushed out. So I made a routine that lets me store the actual Report.rpt file into SQL and when a user goes to run it the report is pulled out of the database and saved into their temporary files and then passes it back to my PrintReports routine as a ReportDocument. This also works fine but only on my machine. On the client machines it asks for the login information and no combination will work. I've tried multiple ways of getting around it and have spent hours trying examples found on the internet including assigning the login information before preview, running through and assigning the login information to each table, I've gone through the "Using Integrated and SQL Autentication in .Net Applications" guide, turning on and off integrated security. Nothing seems to work.
What else is there to try? As a very last resort I will have to store the reports into the app like the other ones but I'm really trying not to do this.