Skip to Content
0
Former Member
Feb 21, 2011 at 03:54 PM

values displayed in report do not match those in underlying data source

34 Views

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