Filter DataType problem
I have a column in my dataset that is datatype: numeric(9,4)
I want to create a Tablix filter on that column, for ColumnName < 3000
What datatype should the Filter be????
Marion in Rochester
January 30th, 2011 6:33pm
Hi,
What you can do is
setp-1:- In expression add =CDec(Fields!value.Value). You need to do this to explicitly select the datatype.
setp-2:- select datatype int.
setp-3:- use "<" as operator
step-4 :- set value 3000.-Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
January 30th, 2011 7:34pm
@Chintak
Thank you, that worked. I may be back with a related question, but you got me back up and running.Marion in Rochester
January 30th, 2011 8:08pm