chizotz at mchsi.com
chizotz at mchsi.com
Wed Sep 7 10:21:38 CDT 2005
Crystal is buggy as a beehive and has its own ideas about a bunch of stuff, meaning it tends to not play nice a lot of the time. It sounds like you're opening a report that has an embedded login that is overridden in the application so it runs fine in production but when you open it up to work on it in a dev environment the embedded login takes over. But that's just a guess. I've had this and all sorts of other hassles with Crystal. Good luck using it, it's not the friendliest of help sites, but here is the Crystal KB. http://support.businessobjects.com/search/default.asp?ref=default.asp_shortcuts > Hi Listers, > Looking for assistance with login problem with SQL. App works fine in > production environment, however when I bring it into a development > environment, the app fails. > > At the line of code: > > crptReport.ReadRecords, which is calling the Crystal Report I get the > 'login failed for user "bob"' and a blank report. However the stored > procedures run perfectly fine with the user bob account up till invoking > the CR. Any clues or ideas where I can research this? > > Thanks for the help.