In our environment we need to write and use SQL that can be connected to a Crystal Report. The database is Oracle 9i. In most cases we will let Crystal generate the SQL for the report, but there are cases where we want to connect the report to SQL that we have written. What are the recommended tools for creating SQL that can be integrated with the Crystal 9 reports?
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!
What are recommended SQL tools for Crystal 9
- Thread starter cmmrfrds
- Start date
synapsevampire
Programmer
I think that you'll find any Select will work, as for tools, you can use PL/SQL Developer or TOAD to generate SQL, amongst a myriad of other tools, including the all too lame SQL Worksheet and SQL Plus which come with Oracle.
With Crystal you can select the data source and then select the Add Command which will allow you to paste in SQL.
A more intelligent and reusable approach is to create Views or Stored Procedures on the database itself.
The above tools will allow for this as well.
I'd consider getting some assistance with the project at first.
-k
With Crystal you can select the data source and then select the Add Command which will allow you to paste in SQL.
A more intelligent and reusable approach is to create Views or Stored Procedures on the database itself.
The above tools will allow for this as well.
I'd consider getting some assistance with the project at first.
-k
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question