That is spot on Sir.

Thanks.

Gillian

Hi There.

Yes, there can be other statuses, but I am just looking for each customer order that may have 1 to n customer order lines, and that the line statuses...

Thank you Kurt. I appreciate you help very much.

Gillian

Hi Kurt.

I hope you had a nice weekend. I read up on the cte and tried to apply your suggestions over the weekend. I keep getting compile errors...

Thank you for your explanation and link. I will will be reading this tonight and hope I can get it to work sometime tomorrow.

I really appreciate you help and...

Thank you very much for you help and I understand. Sorry for my ignorance.

DECLARE @TempCOGGP TABLE

(conum varchar(10),

coline varchar(10),

itemnum varchar(35),

custnum varchar(10),

custseq int,

qtyorder decimal (10,8),

qtyready decimal (10,8),

qtyship decimal (10,8),

promise...

Thank you very much Kurt. That is awesome and is exactly what they are looking for.

Pardon my ignorance but I have never seen ;with before, and are you using...

Hi Sean.

Here is my table.

DECLARE @TempCOGGP TABLE

(conum varchar(10),

coline varchar(10),

itemnum varchar(35),

custnum varchar(10),

custseq int,

qtyorder decimal (10,8),

qtyready decimal (10,8),

qtyship decimal (10,8),

promise date,

ship date,

orderdate date,

coitemstat varchar(3),

allocate date,

pattern varchar(3),

room varchar(1),

Tag varchar(1)

)

Thank you Sean.

Sorry about the mess.

Hi. Thank you again for your response. That works very well to get rid of either status C or O, but what they want me...

Hi. Thank you again for your response. That works very well to get rid of either status C or O, but what they want me to do is...

Hi. Thank you for your response. I really appreciate all of the help here and so quickly too. I will give this a try too.

Thank you very much, I am going to try that right now.

Thank you very much, I will try that right now.

Thanks for your help......I got it to work....

=IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2 and Fields!KeptAppointments.Value = 1, 1,0)

That is the formula that I added to Visual Studio 2008 calculated formula

=IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2, Fields!NeedUrgentDates, 1)

Input field Urgency_level can = 1 - 4, and the Field...