Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Type in SQL in CR10?

Status
Not open for further replies.
nagornyi

nagornyi

MIS
Nov 19, 2003
882
US
In CR10, I need to type the SQL directly, like it used to be in Crystal Query the old days.
How?
 
Sort by date Sort by votes
When you go to add a table/view/stored proceudre, there is an option named 'Add Command'. By choosing that, you can define your own SQL to be used for a report.

-dave
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

G
  • Locked
  • Question
Multiple groups in same level
Replies
0
Views
213
george1610
G
K
  • Locked
  • Question
We're using command in crystal report
Replies
1
Views
614
hilfy
hilfy
JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
552
SoftwareRT
SoftwareRT
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
937
hilfy
hilfy
D
  • Locked
  • Question
Open a report into Design mode
Replies
0
Views
259
drb1980
D

Part and Inventory Search

Sponsor

Back
Top