Oracle and crystal reports line charts [message #170871] |
Fri, 05 May 2006 11:23 |
MrhelpMe
Messages: 9 Registered: May 2006
|
Junior Member |
|
|
Using crystal reports 9.0 and have created stored procedure in oracle to work with report. Having issues with line charting the noted subset of data below.
TSK000000181893 1 23-APR-06 0 1
TSK000000181908 0 (null) 0 0
TSK000000182210 0 (null) 0 0
TSK000000182218 1 02-APR-06 1 0
TSK000000182225 1 09-APR-06 1 0
Looking at the subset of data, we can see that there are 2 values will null in them. Since a line chart is being used, the line will start from the zero mark or null value and continue to plot the remaining values. This is not what I want. I need the line graph to ignore all nulls and start from a valid date and continue plotting.
The statement that is creating null values into the field is as follows.
(CASE when status = 4 and convert_utc_date(Actual_End_date,'MDT') between trunc(sysdate,'WW')-28
and trunc(sysdate,'WW') then (trunc(convert_utc_date(Actual_End_date,'MDT'), 'W')+1)
End)Last4WeeksStartWeek
Any ideas how to remove or take care of this either through oracle or crystal reports. I would really appreciate this. Thanks.
|
|
|