Skip to Content
Former Member
Aug 05, 2009 at 03:51 PM

Command with Complex Sql statement not returning valid result set


I'm using Crystal Reports 12 and running against an Oracle 10g database. I'm using a complex sql statement which includes several union clauses and subqueries in the data command as my report data source. It is returning the correct number of rows and the data is valid except for one column which is set to zero for 3 of the 4 rows and null on the other row. If I run the same statement in Aqua Data Studio or PL/SQL Developer it returns 4 rows with values for each of the columns. All of the data matches except for the one column that Crystal Reports recognizes is there, and that it is a number, and allows me to add it to the report but which does not contain the values that should be generated by the sql.