Stored Proc Nulls displayed as zeros!

[tman135]

I've got a complicated stored proc building a result set to feed to crystal. Some fields have nulls values. If there is data in the field, it is decimal value.

I want to group this data based on a date range and then averages of the fields which may contain nulls. Crystal is showing 0.00 for all null values and then averages the 0.00 in with the real data on a summary. If I have 8.5 and 0.00 (which is really null) I want the average to be 8.5.

Any help would be appreciated

 

[balves]

You can create a summary field or running total (depending upon your version of Crystal).

In the middle frame called "Evaluate" click on the Formula button and create a formula for when the field is not null. Fill the Summary frame (average, sum, count) and Reset frame (reset on a group, never reset, etc.) as needed.

 

[idle]

A Report Option is to convert null values to default, which in this case would be zero. Sounds like you want to ensure this option is not selected, so that you get nulls returned in an unconverted state.