Hi,
    I'm using CROSS tab report in crystal report - X1. All the grouping and getting Total are done using backend SQL query.

In the last section of the query, I'm updating (assigning ) the value of vertical growing column to 99999 using update statement wherever there are zero or NULL values.

In crystal report, randomly ONLY ONE RECORD is showing garbage value it seems like it is almost adding the existing value (data type DECIAMAL(12,2)) with 99999. But in sql server browser it is showing correctly.

Not sure what is the problem.
Appreciate anyone can help on it, where I'm doing wrong.

Regards,
Lokesh