i'm using crystal XI against an oracle db using oracle ODBC drivers.

i have a report that uses a linked view and table from the database.  i need to add a small "table/view" that is not currently present in the db to do a quick look up to get a code description.

i have the sql code to select the table, now, can i somehow generate this "table/view" in crystal?  or do i have to add it to the db as a view?

i have tried to Add Command which sort of works.  i have had a series of different errors:

• database vendor code: 942
• database vendor code: 922

thanks

sandy


Edited by sbodell - 13 Jul 2009 at 12:54pm