• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

Creating a report with SQL on Crystal

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.

Thanks!
0
horalia
Asked:
horalia
1 Solution
 
peter57rCommented:
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.

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

Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now