No, it's actually the export that takes so long to run. If you write your Crystal reports directly off the SQL database, they run much faster. Drew J. Drew Allen Children's Hospital of Philadelphia [Email Removed] Check out the user run RE Forum at http://www.blackbus.org/ . Check out the Crystal Reports blog "Crystal Clear" at http://www.blackbus.org/blogs/viewblog.php?userid=63

Dom, Could you please email me the steps you take. I have built a query in BB but I can not find a view menu-SQl any wheres. My email is [Email Removed]

That's probably because you haven't unlocked the RODBA module yet. I created a case and they emailed me an unlock code. I ran into some problems with authentication though. We're set to Windows Authentication in SQL Server so I had to give my AD account (via Enterprise Manager) full dbo access (temporarily) to the re7 database. Once the module was unlocked, I returned my account back to normal and I was able to view my sql behind my queries. Kind of nice, except I'm still not used to joining tables in the FROM statement - seems like too much typing. I'm used to Oracle 9i and still like to do it in the WHERE clause. Dan Larson Programmer/Analyst St. Cloud Hospital St. Cloud, Minnesota

Technically you can do it in the WHERE clause Don because SQL server uses ANSI SQL, and that's the standard. I do it in my scripts all the time because I (like you) love Oracle and some of the powers it has that SQL server doesn't... I believe that SQL is more efficient if you do it in the FROM clause, but I haven't noticed any real speed decreases from doing it the other way, and one of my scripts is about 7000 lines of code... Doug Creek University of Alaska Database Administrator [Email Removed] Visit the RE User Forums! http://www.reusers.server-planet.com/

SQL Books On Line has the following to say about the difference between specifying join conditions in the FROM clause and the WHERE clause. [indent]Specifying the join conditions in the FROM clause helps separate them from any other search conditions that may be specified in a WHERE clause, and is the recommended method for specifying joins.[/indent] You should also note, that ANSI SQL requires OUTER JOINS to be specified in the FROM clause. Drew J. Drew Allen Children's Hospital of Philadelphia [Email Removed] Check out the user run RE Forum at http://www.blackbus.org/ . Check out the Crystal Reports blog "Crystal Clear" at http://www.blackbus.org/blogs/viewblog.php?userid=63