Creating a report with SQL on Crystal

Posted on 2011-10-27
Medium Priority
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

peter57r earned 2000 total points
ID: 37039517
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

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


Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

839 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