Creating a report with SQL on Crystal

Posted on 2011-10-27
Last Modified: 2012-05-12
Hello Experts,

I need to create a Crystal Report with a new stored procedure. Since I don't have MSSQL installed on my PC, I was wondering if there is a way to write the SQL statement directly on Crystal, and how this can be done.

Question by:horalia
    LVL 77

    Accepted Solution

    I'm not sure i really understand your Q. If you haven't got MSSQL then how can you create a data source based on a SQLSERVER database at all?

    But as a general answer- to base the report on a sql statement you use the 'Add command' option that appears at the top of the list of tables after you have created your connection.  You have to write the SQL statement as a text string.  There is no help within CR for this. It just sends the statement to the database for execution.


    Author Closing Comment

    Exactly what I needed, wish I had known this a long time ago. Would have saved so much creating unnecessary stored procedures!


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    728 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

    18 Experts available now in Live!

    Get 1:1 Help Now