Thanks for trying

There is nothing in the rdl that would indicate any kind of line break. The problem only happens in the Report Manager Preview Screen not in the Developer Visual...

Thanks I will look at that and let you know what I find.

So - after reading all of this and being totally confused. Is there an answer. Can I link (therefor group) mutliple datasets to return one record per...

Thank you all for your input all is well and working great.

Stop the presses

I was checking character by character there was a space at the begining of my variable name, it wasn't recognizing it. Whooppee it works, I can't thank...

Sorry it is rendering but not sorting at all.

I checked all my Text options work and doing a straight convert the dates sort Alphbetically April, August etc....

So how do I get it out of here

My clause looks like this

when 'SchedDate' then CONVERT(varchar(30),cast(CASE Item.[Scheduled Date] WHEN '1753-01-01 00:00:00.000' Then '12-31-2049'

...

I do not get any sorting happening at all when I use your suggestion - any more suggestions

😉 Thanks

WHEN 'MSDue' then CASE CONVERT(VARCHAR(19),Job.[MS Due Date],120) WHEN '1753-01-01...

OK great I now have the recored all in one place. How then do I display them together with the basic record

I need:-)

Job information detail line

...

I think I got it. I will do that and get back to you if I need additional assistance. Thank you so much.

Barb

Do you mean I would create a temporary table. The information is in the Task Comments Table how would I tell it to form one record by job number...