Dear support,
It was very strange that for a report that a report created using OLE DB ( MS for Oracle ). When "Show SQL Query" all tables are properly prefixed with owner ( e.g. "OWNER"."TABLE_NAME" ). When previewing data using Oracle user other than owner, the preview works fine. However, when running the report in Crystal Viewer, all prefixes were gone. Since the user in Crystal Viewer is not the owner, ORA-00942 appears. Please see attached CR log that displays the SQL within ( without table prefix "TFM". )
However, some report works, but not this particular report. Is there any settings that can make it always prefixed with table owner?
Thanks!
-- Alex
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.