Charting Question

[Leighton21]

Hi All,

I have an SQL TABLE which has a column of dates and a column of values for those dates. some of the values are null and when I create a chart the dates alon the axis appear when the value for that date is null.

Is there a formula to filter the dates where the value is null

Cheers

 

[Madawc]

You could get rid of the records with null in record selection, e.g.

not isnull({your.date})

If you need those records for something else, try a formula, but that depends on your Crystal version. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Leighton21]

Cheers Madawc,

I have version 11 think I have to use a formula because there are three charts and they look at different date intervals

Cheers

 

[lbass]

You could use a conditional formula for both the "on change of" field and the summary field as in:

//{@onchgof}:
if not isnull({table.date}) or
{table.date} <> date(0,0,0) then
{table.date}

//{@summary}:
if not isnull({table.date}) or
{table.date} <> date(0,0,0) then
{table.amt}

This will eliminate the axis label. However, if you are using a legend, there might be an unlabeled colored box corresponding to the default values. If this is an issue, your best bet is create the chart in a subreport where you can filter out the nulls in a record selection formula.

-LB