I'm using Crystal as part of Visual Studio and have a SQL query that runs in < 20 sec. in SQL Server 2000 Query Analyzer. When I cut and paste it as a command in Crystal Reports it runs in ~30 minutes. Any suggestions as to where I should start looking to speed this up? Thanks.