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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Import SQL code to Crystal Reports 1
- Thread starter hearnp
- Start date
-
1
- #2
synapsevampire
Programmer
Try to learn what version of Crystal you might be using. One line posts invariably cause others to guess and wastes everyone's time (just like calling technical support, the answer is often different across different versions of the software).
In CR 9 and above, there is a Command Object, and you can paste in real SQL, prior to that one could paste in SQL using an ADO connection, however parameters weren't passed to the database in those types of coneections.
If CR 9 or above, under the connectivity for Oracle, you'll see Add Command, just paste in the SQL that will work as the datasource, and you can generate parmaeters for the SQL at the same time.
-k
In CR 9 and above, there is a Command Object, and you can paste in real SQL, prior to that one could paste in SQL using an ADO connection, however parameters weren't passed to the database in those types of coneections.
If CR 9 or above, under the connectivity for Oracle, you'll see Add Command, just paste in the SQL that will work as the datasource, and you can generate parmaeters for the SQL at the same time.
-k
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question