hi -- I have a report based on a view. The view contains a date (never null) and several numeric value columns
which can be null. The dates are outer joined to a date table, so even in Feb of 2011, the view will
have a month date for every month of the year, but the other columns are null values for Feb - Dec.
January does have values.
So, the view data (queried from sqlplus) is correct. However, when that view is queried via a Crystal report, all
data except the date is null -- even for complete years where there's a value for every month.
When I modify the view to replace nulls with 0s, all values (even the ones that are not null / not 0 when querying the view)
are now displayed as 0.
The dates are correct, and the database fields in question are in a details section; I can't figure out what's going on.
Ideas?
Thanks,
Carol