I have a complex SQL query that used to be run in SQL query analyzer that could be used in a crystal report. When I add the tables that are in the query to the report and then paste the SQL into the View SQL window in Crystal, everything except the Select portion of the statement copies over correctly. The select only shows up as Select Field1, ... Then there should be additional fields but they are not there. Is there something that can be done to include those? It would just be a time saver rather than recreating the SQL through the report builder. Anyone have thoughts on this?
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!
Paste in SQL query
- Thread starter hermantb
- Start date
synapsevampire
Programmer
What version of Crystal are you using?
Consider creating a View or SP from the SQL if you're using version 8.5 or below.
In CR 9 the SQL should paste just fine unless perhaps the naming convention annoys Crystal.
-k
Consider creating a View or SP from the SQL if you're using version 8.5 or below.
In CR 9 the SQL should paste just fine unless perhaps the naming convention annoys Crystal.
-k
- Status
Similar threads
- Locked
- Question