Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: alex_vlm@yahoo.com (Alex) Newsgroups: comp.databases.oracle.tools Subject: How to use Crystal Reports with Oracle Date: 4 Apr 2002 09:36:48 -0800 Organization: http://groups.google.com/ Lines: 13 Message-ID: NNTP-Posting-Host: 172.145.138.26 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1017941808 4352 127.0.0.1 (4 Apr 2002 17:36:48 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 4 Apr 2002 17:36:48 GMT Xref: easynews comp.databases.oracle.tools:50398 X-Received-Date: Thu, 04 Apr 2002 10:34:34 MST (news.easynews.com) Hello, 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!