crystal reports sql command vs view

Posted on 2011-04-28
Last Modified: 2012-05-11
Can anyone tell me why a crystal report using a sql command runs much slower than a crystal using a view (same code as the sql command)? Could it be that the sql command is executed locally and the view is on the server? Crystal Reports XI.
Question by:qbjgqbjg
    LVL 77

    Accepted Solution

    The sql command is definitely NOT executed locally.  CR has no ability to do such things.
    The command is submitted to the database server which executes it.

    There are probably management tools on SQL Server that would enable you to see how each request was executed, but on the face of it , i agree it does sound a bit odd.

    LVL 100

    Expert Comment

    Are you  using the same filtering?

    How are you determining that it is slower?

    LVL 100

    Assisted Solution

    When you run it each way can you show what the SQL is?

    That will show what was passed to the database.


    Author Comment

    I am using no additional filtering. Only what is in the sql. I know that it is slower, because I press the button, then wait awhile with the sql command, but with the view it comes back fairly quickly. I have looked at the sql using show sql, it is exactly what is in the sql command.

    Author Closing Comment

    Thanks for your comments.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now