- 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...