How to do adhoc Oracle queries in Crystal Reports 
Author Message
 How to do adhoc Oracle queries in Crystal Reports


I am trying to create reports in Crystal Reports 6 Pro from Personal
Oracle 8i. I am using ODBC in Crystal to connect to Oracle. Everything
is running on Windows Millennium.

In Crystal: When I go to new report -> Data -> SQL/ODBC -> I get
connected -> Choose SQL Table box. In Choose SQL Table box I only can
choose tables and views. So for example if I want to do select query
from several tables my only choice is to create view in Oracle and
open it in Crystal? Can I do ad-hoc queries in Crystal?

Would very much appreciate any response!

Tue, 21 Sep 2004 14:09:12 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Adhoc Query Form - but not very user friendly

2. Adhoc query from VB6

3. Interested in adhoc query builder for VB?

4. Help! Re:Parameter or Adhoc query in expression

5. Using Sub Query in Sql Query - Crystal Report 5.0

6. Crystal report based on Crystal query, doesnt work

7. Report Control VB6 - How to give users Adhoc designer

8. Adhoc Reporting tool?

9. CRYSTAL REPORT, run time query report by date

10. Q: Pass a SQL query from VB to crystal report sub-report

11. sub-report (2 query's ) in crystal reports

12. Help with a join query into Crystal Reports 6 Exception Report


Powered by phpBB® Forum Software