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.
Any ideas? Thanks.