Null values in line charts

Hello,
I use the RS to charting some blood tests results (i work in an hospital).
These results have:
Date:DateTime
Results:Int
At a specific Date one blood test has not a result (in database is NULL).
The problem is that in line chart this appear as 0 values (this is very bad
for our patient-for doctors this mean something about the patient health).
My table
Date Test1Result Test2Result
12.02.2004 125 34
16.04.2004 NULL 25
18.08.2004 128 NULL
In the report i have 2 line charts 1 for test1result and 1 for test2resolt.
The doctors must see both charts. How to hide this 0 values (something like
Excel with zero values)
Thank youIn the field (or textbox) in which the value displays (the zero you
dont want) - Change the expression to say:
IIF(IsDbNull(Fields!Test1Result.Value) = True, (whatever value you want
to return instead of zero), Fields!Test1Result.Value)
Optionally - if this is from a Stored Procedure you could change the
Procedure to replace NULLS with someother more useful value.
The context here is a little vague.. I hope this helps.|||Thank you for your help. I can't insert any value here because this reflect
the patient healt state.
"papaboom" wrote:
> In the field (or textbox) in which the value displays (the zero you
> dont want) - Change the expression to say:
> IIF(IsDbNull(Fields!Test1Result.Value) = True, (whatever value you want
> to return instead of zero), Fields!Test1Result.Value)
> Optionally - if this is from a Stored Procedure you could change the
> Procedure to replace NULLS with someother more useful value.
> The context here is a little vague.. I hope this helps.
>|||Please read this thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=a3bce317-0626-47f4-9ec2-aebe559a41b3&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"cleo_mihai" <cleo_mihai@.discussions.microsoft.com> wrote in message
news:DDCBA342-D771-4868-8009-5FC30D5ECB26@.microsoft.com...
> Hello,
> I use the RS to charting some blood tests results (i work in an hospital).
> These results have:
> Date:DateTime
> Results:Int
> At a specific Date one blood test has not a result (in database is NULL).
> The problem is that in line chart this appear as 0 values (this is very
bad
> for our patient-for doctors this mean something about the patient health).
> My table
> Date Test1Result Test2Result
> 12.02.2004 125 34
> 16.04.2004 NULL 25
> 18.08.2004 128 NULL
> In the report i have 2 line charts 1 for test1result and 1 for
test2resolt.
> The doctors must see both charts. How to hide this 0 values (something
like
> Excel with zero values)
> Thank you
>|||Hy,
After 5 months and sp2 of RS, is time to try to solve my problem (unsolved
yet).
First, because the 0 value can't appear without a reason (this value
represent something-(eventually the patient's health status is bad)- i can't
replace the null's with any value (or 0). I can not decide if patient health
is good or bad. This must be a result from laboratory.
Second, is so complicated in RS to hide the null values? In Excel is easy
"Plot empty cells as: Interpolated".
If this is impossible in RS please let me know, to look for other charting
solutions.
Thank you very much for your time,
"cleo_mihai" wrote:
> Hello,
> I use the RS to charting some blood tests results (i work in an hospital).
> These results have:
> Date:DateTime
> Results:Int
> At a specific Date one blood test has not a result (in database is NULL).
> The problem is that in line chart this appear as 0 values (this is very bad
> for our patient-for doctors this mean something about the patient health).
> My table
> Date Test1Result Test2Result
> 12.02.2004 125 34
> 16.04.2004 NULL 25
> 18.08.2004 128 NULL
> In the report i have 2 line charts 1 for test1result and 1 for test2resolt.
> The doctors must see both charts. How to hide this 0 values (something like
> Excel with zero values)
> Thank you
>|||Are you sure you have tried this on SP2? Empty data points (i.e. value =Nothing) in line and area charts will be ignored and "interpolated".
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"cleo_mihai" <cleomihai@.discussions.microsoft.com> wrote in message
news:9B015D0A-BB60-4615-8410-91F11832E3FD@.microsoft.com...
> Hy,
> After 5 months and sp2 of RS, is time to try to solve my problem (unsolved
> yet).
> First, because the 0 value can't appear without a reason (this value
> represent something-(eventually the patient's health status is bad)- i
> can't
> replace the null's with any value (or 0). I can not decide if patient
> health
> is good or bad. This must be a result from laboratory.
> Second, is so complicated in RS to hide the null values? In Excel is easy
> "Plot empty cells as: Interpolated".
> If this is impossible in RS please let me know, to look for other charting
> solutions.
> Thank you very much for your time,
>
> "cleo_mihai" wrote:
>> Hello,
>> I use the RS to charting some blood tests results (i work in an
>> hospital).
>> These results have:
>> Date:DateTime
>> Results:Int
>> At a specific Date one blood test has not a result (in database is NULL).
>> The problem is that in line chart this appear as 0 values (this is very
>> bad
>> for our patient-for doctors this mean something about the patient
>> health).
>> My table
>> Date Test1Result Test2Result
>> 12.02.2004 125 34
>> 16.04.2004 NULL 25
>> 18.08.2004 128 NULL
>> In the report i have 2 line charts 1 for test1result and 1 for
>> test2resolt.
>> The doctors must see both charts. How to hide this 0 values (something
>> like
>> Excel with zero values)
>> Thank you