Null Values in Chart 1

[lcfc]

Can anybody tell me how to supress null values in a chart?

 

[IdoMillet]

See:

http://support.businessobjects.com/communityCS/TechnicalPapers/cr_line_chart_nulls.pdf

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lcfc]

Hi thanks for responding. It is not a line chart, but a bar. The null values just leave a 'blank' column

 

[lbass]

One approach is to create a formula:

if not isnull({table.summaryfield}) then {table.onchangeoffield}

Substitute your chart fields for {table.summaryfield} and {table.onchangeoffield}. Then use this formula as the "on change of" field. This will result in one bar per x-axis value that is non-null, but will also include one bar representing all nulls. In the chart expert, highlight the "on change of" field->order and choose "specified order". Add the non-null x-axis values by using the drop-down list. Then choose the "other" tab and choose "discard all others." This will eliminate the "nulls" bar.

If you might have different x-axis values depending upon a parameter in your record selection statement, first run the report with all values and add them into the specified order list so that the appropriate values are available to appear when a new parameter value is chosen.

-LB

 

[gbrian]

That doesn't work as I can't select the formula in the ORDER sorting.. the count({Membership.WTCOUNTRY},{Membership.WTCOUNTRY}) is what causes this

 

[lbass]

Please see my response in your thread--you were misinterpreting the suggestion.

-LB