The NULL is a real NULL

and I'm expecting the max kms_quoteorder

so if there are no /REV then I should only see the number.

The /REV stands for Revision. Poorly...

CREATE TABLE test

(

createdon datetime,

kms_quoteorder varchar(15)

)

INSERT INTO test VALUES ('2015-06-10 14:03:04.000','NULL')

INSERT INTO test VALUES ('2015-07-22 15:13:39.000','15-37666')

INSERT INTO test VALUES ('2015-07-22 16:13:39.000','15-37779/Rev7')

INSERT INTO test VALUES ('2015-07-22 19:54:56.000','15-37779/Rev8')

INSERT INTO test VALUES ('2015-07-22...

Sorry about that. The values are for kms_quotenumber are

EX.

NULL

12-00013

13-01646/Rev1

13-01646/Rev10

I get this error

Msg 537, Level 16, State 3, Line 1

Invalid length parameter passed to the LEFT or SUBSTRING function.

CREATE TABLE test

(

createdon datetime,

kms_quoteorder varchar(15)

)

INSERT INTO test VALUES ('2015-07-22 16:13:39.000','15-37779/Rev7')

INSERT INTO test VALUES ('2015-07-22 19:54:56.000','15-37779/Rev8')

INSERT INTO test VALUES ('2015-07-22 20:26:41.000','15-35553/Rev9')

INSERT INTO test VALUES ('2015-07-22 21:32:31.000','15-35553/Rev10')

select * from test

drop table...

That works with only '15-35553%

that was just an example of one type of quote number. I want the make of any quote number added.

so when I took the where...

Was this ever figured out? I having the same problem?

Here is a example of what is happening

I have two datasets

lets just say dataset3 and dataset4

When I run this:

=Sum(Fields!S125.Value, "DataSet4")

It gives me the sum of each employee in one total.

This...

I spoke to fast

I use these two expressions to get totals by state:

1. =Iif(trim(First(Fields!SUTASTAT.Value, "DataSet5")) = "OK", Sum(Fields!FICAMWPR.Value, "DataSet5"),cdbl(0))+Iif(trim(First(Fields!SUTASTAT.Value, "DataSet5")) = "OK", Sum(Fields!FCASWPR.Value, "DataSet5"),cdbl(0))

2=Iif(trim(First(Fields!SUTASTAT.Value, "DataSet5")) = "LA", Sum(Fields!FICAMWPR.Value, "DataSet5"),cdbl(0))+Iif(trim(First(Fields!SUTASTAT.Value, "DataSet5"))...

I figured it out. I had to go another direction

Nevermind, it came over as <

as &lt not <

It didn't like the <

I replaced it with < and it worked.

It doesnt like the <

= iif(DateDiff("d",fields!STRTDATE.Value,today()) < 60, DateDiff("d",fields!STRTDATE.Value, today()), "Date not less than 60")

numeric(19,5)

It works now, i had to drop and add the SP once I changed the two new fields from nvarchar to INT