Tech Support > Microsoft Windows > Windows CRM > Report Crystal Report on CRM 1.2 Problem
Report Crystal Report on CRM 1.2 Problem
Posted by Chdup on January 31st, 2006


Hi,

I create a Crystal report.

in this reports, i use "field of cumulated total"
Sorry, i am french and in french it's
"Champs de total cumulé"

I use result of this field to do statistic.

the problem,

When the fields is null, result of my stat are null too.

Can you help me.

thanks


Posted by Dave Ireland on January 31st, 2006



depending on the source of your data, you can use the
ISNULL(fieldname,0,fieldname) T-SQL function to replace null values with
zero values instead. This will allow your statistics to compute properly.

Dave

"Chdup" <chdup@monmail.com> wrote in message
news:43df6e55$0$608$636a15ce@news.free.fr...


Posted by Chdup on January 31st, 2006


Yes, it s the solution, i have just find.
In first, i would like find a parameter in crystal report to replace null by
0

thanks


"Dave Ireland" <direland@salentica.com> a écrit dans le message de news:
elIHGfoJGHA.2040@TK2MSFTNGP14.phx.gbl...



Similar Posts