failed to retrieve data from the database

jaga23

Thanks in advance if you reply.

Trying to run a report through Cystal Delivery that works fine executing through Crystal Reports. But when trying to view through Crystal Delivery, am getting error "Failed to retrieve data from the database. Database vendor code: 904"

Login info is correct and using a Oracle 10.2 database.

Compared to other working reports via Crystal Delivery, this particular one has a custom SQL statement, and only has a login line for one table, and not the tables included in the custom SQL.

Anyone seen this? Solutions?

Thanks again!