Skip to Content
0
Former Member
Jan 18, 2012 at 08:10 PM

Crystal Reports using Oracle View

61 Views

I have an Oracle View which selects data based on a date range. When I run a SQL statement to access my View, it returns the expected data. When I try to access the view through Crystal, I get nothing returned.

When I leave just the lower limit of the range and remove the upper range, the Crystal report returns the data.

I have no selection formulas on the report, no parameters, nothing fancy (yet). I just want to get the data from the view. I'm using Crystal 8.5.

Any ideas? Thanks.