Re: classic ora-00904 & Crystal

MarkD wrote:
> Hi,
> Im new to oracle but I do have a background in sql server.
>
> I created a view and attached it as a datasource in Crystal. I can add the
> fields to the report, but when I preview the report, I get "ODBC Error
> ..... ORA-00904: invalid identifier". I've been looking for a solution for
> a few days and no one seems to know.
>
> Thanks in advance
> Mark D

What version of Oracle?
What version of Crystal?
Don't use ODBC ... use the native Oracle connection What are the field names of the table(s).

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)