Crystal Reports in .Net

I have been grappling with a "Logon failed" problem with Crystal reports in Net through VS.Net using the "pull" method

Good overview here

"Crystal Report for Visual Studio .NET"
http://aspalliance.com/articleViewer.aspx?aId=265

However it gave a "logon failed" error.

After a number of days searching for the solution I tried

- Updating the crystal report assemblies in web.config to version 9.1.5000.0 for vs.net 2003
- Updating the crystal runtime with the lastest patches from Seagate and MS
- Calling it using the push method passing a typed dataset as the report source, which I got to work more easily !

This

"Understanding the Login Failed error"
http://aspalliance.com/articleViewer.aspx?aId=532

Eventually gave me the solution by reconfiguring the data source to OLEDB and fixing up the report. Then se the correct permission on the template and output paths to allow ASPNET account write permission to it.

Conclusion : Crystal in Vs.Net is fragile to get working, not looking forward to the deployment issues across 36 sites ;-(