Crystal Reports Designer Freezing

Discussion created by Rob-FCB on Dec 3, 2010
Latest reply on Dec 3, 2010 by Chris_Hackett
I am getting an issue while using Crystal Reports designer to build custom reports in which if I try to use the Add Command function to write a custom SQL query, it completely freezes up on me and I have to kill it from Task Manager.

If I use a database view or table(s), it works fine.

We have reinstalled Crystal and the problem was resolved only to resurface a few weeks later.

Running Windows XP SP2 with Crystal XI R2 SP6

Just wondering if anyone else has seen this behavior when trying to create reports and if there is any workaround.