Hi,
I've just been caught by the short and curlies by this one: spent a whole day with a client wondering why my report wouldn't work. Lesson No. 2 in this article did the trick: you cannot create a report using Integrated Security and then use SQL Server Security afterwards i.e. build the report in a test environment using INtegrated and then transfer to production and use SQL authentication,
http://aspalliance.com/532_Understan...rystal_Reports

Thanks to Richard Dudley.