Thank you very much for your assistance.

Implementing CTEs enabled me to complete the solution.

I am always trying to find the "correct" way to write SQL code and I thank you...

Edited out

Thank you for your response.

I was able to create a CTE for the first part of my code.

You indicated that I should not use Table1.TDL_ID as a key for everything...

That did it!

Thank you very much!

I don't know if there is a more efficient way to do this, but I resolved this by making the parameter a multiple.

I modified both datasets to accept multiples. (ie....

This was very helpful! Thank you!

btw...

The function called in the SP is this:

FUNCTION [dbo].[FnSplit]

(

@List nvarchar(2000),

@SplitOn nvarchar(5)

)

RETURNS @RtnValue table

(

Id int identity(1,1),

Value nvarchar(100)

)

AS

BEGIN

While (Charindex(@SplitOn,@List)>0)

Begin

Insert Into @RtnValue (value)

Select

Value = ltrim(rtrim(Substring(@List,1,Charindex(@SplitOn,@List)-1)))

Set...

Thank you very much!

That worked.

I see how you did that.

I just wasn't thinking about the solution that way.

Thank you for your efforts!

It should be 50%:

6 total entries

1 Early, 1 On Time for LSM

1 On Time for RSM

Here is a sample report with sample data.

I hope that I did this correctly.

I would like the Percentage in Textbox70 to reflect the total percentage of On Time for the...

All,

I was able to resolve this issue using this code:

= DatePart("ww",Fields!duedate.Value,IIF(year(Fields!duedate.Value) > 2010,vbSunday,vbSaturday))

This provided the week number and I was able to go from there.

The StrReverse was the culprit.

I thought I needed the StrReverse to get the correct data.

Obviously not.

Thank you.

Mark,

Thank you very much!

That approach worked perfectly.

They are individual varchar cells.

I spoke with the program developers and they said that there are no columns like that.

That is why I was going to bail.

I spoke with a gentleman that is an...