Matrix dataset filter out null

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

magendo_man - 31 Jul 2006 17:11 GMT

I have a dataset which has a ContractNo column which can take a null value. I
cannot carry out the filter on the stored procedure which generates my
dataset.

This dataset is used in a matrix. I need to filter out all rows with a null
ContractNo. I thought I could do this on the matrix properties filter tab
with an expression like:

Fields!ContractNo.Value<>Nothing

However there doeas not appear to be a <> (or not equal to) operator in the
drop-down list in RS2000.

How do I achieve this filter?

What is the != operator?

TIA,
Mageno_man

Reply to this Message

Ben Watts - 31 Jul 2006 17:26 GMT

Dont know if this will help, but the way I have used to get around it is:
Fields!ContractNo.Value<>Nothing in the formula and make the operator the =
and then the value "=true"

Expression Operator
Value
Fields!ContractNo.Value<>Nothing =
=true

I hope this makes sense.

>I have a dataset which has a ContractNo column which can take a null value.
>I
[quoted text clipped - 18 lines]
> TIA,
> Mageno_man

Reply to this Message

magendo_man - 31 Jul 2006 19:53 GMT

Had to put an equals sign in expression, i.e expression is
=Fields!ContractNo.Value<>Nothing

> Dont know if this will help, but the way I have used to get around it is:
> Fields!ContractNo.Value<>Nothing in the formula and make the operator the =
[quoted text clipped - 29 lines]
> > TIA,
> > Mageno_man

Reply to this Message

Jacek - 31 Jul 2006 17:33 GMT

!= is 'does not equal to'

does it solve your problem? :)

> I have a dataset which has a ContractNo column which can take a null value. I
> cannot carry out the filter on the stored procedure which generates my
[quoted text clipped - 15 lines]
> TIA,
> Mageno_man

Reply to this Message