A menagerie of random thoughts and utterings

Crystal Reports nightmare

, posted: 26-May-2006 16:53

Unfortunately I had to create some reports for a kind of Smart Client app. The report was to be deployed and used on several Tablet PCs. I had this bright idea of using "localhost" as datasource so it can be deployed with no extra configuration. That was the beginning of my nightmare...

The development was on VS.NET 2003, using the Crystal component that came standard with the IDE.

For some bizarre reason the report had no problems logging on to the local DB for local admin user. Anybody else (including domain admin) were rejected! Any attempts to provide even the correct credentials were rejected.

In the end I gave up and contacted Crystal folks to see if they could help. It was one of the most frustrating experience I've ever had with a tech support/helpdesk. Admittedly I have had helpful assistance from them before but this time it felt like chasing my own tail.

At last I found the culprit! Using localhost turned out to be a bad idea!! For yet another bizarre reason CR automatically create the connection to use Integrated Security, even when you specify the UserID/Password and left the Integrated Security option unticked. Any attempts to provide the credentials programatically were thoroughly ignored.

I had to create the report by specifying a server name, and later when it's loaded into the viewer I then changed it to "localhost" and pass in the appropriate credentials. That seemed to have done the trick! So there ya go.... hopefully someone will find this useful before they end up tearing their hair out like I almost did.

Other related posts:
Logging feature in applications

dpw's profile

Dany Wu
New Zealand