Joined: 31 Mar 2011
Location: India
Online Status: Offline
Posts: 3
Topic: Displaying BAD data Posted: 19 Dec 2011 at 5:25am
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.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged