I write a rather complex (several inner and outer joins and one "not in" clause) query using Oracle's SQL Developer and get results. I then paste the query into a command as the source of a Crystal Report. For this particular query, SQL developer returns 27 rows and Crystal Reports returns zero. There are no parameters to the command and I have performed no selecting in the report. I have 50 or more reports in my application that all work as expected with this one exception. What is prohibiting Crystal Reports from passing the command through to Oracle unchanged?
There is one limitation in Native (Oracle Server) connection in Crystal Reports connecting to Command Object, View or Stored Procedure. It supports only specific Date format. If you have hardcoded Date selection in your query - it could be the cause.
Ian, you got me thinking. I changed the database location and created a new connection using OLE DB. Although it runs a little slower, the report now returns the correct results. Any idea why the "Oracle Server" connection would not return any results?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.