Thanks for your advise. I am looking at it now.

Please note that the SSRS server is on the actual SQL Server box - and I am certain they both use...

Tx Sean, you're right.

I have done away with the weekday name and reduced the report to a single page (maybe 2) by creating a rep parameter as a filter.

Still...

Tx,

I'll try that, but this is a 64 bit server with 64 GB RAM, I've never seen it go beyond 50% mem useage. When I look at the...

Ok Guys,

I have posted the SQL (See prev post) and the execution plan. I have added the missing indexes, and finally I have added a 'rep' parameter so that the...

Ok, here we go:

NO SP - it is a very simple query -

select sed.RM,

SED.DM 'Supervisor',

SED.[week] 'LCL_Weekno',

SED.projectNumber,

SED.ProjectName 'ProjName',

SES.Total_Shifts,

SED.Staff,

SED.shifts 'Shift',

SED.daysdelay,

SED.locationnumber,

SED.earliestStartDate,

case when DATEPART(DW, SED.earlieststartdate) = 1 then 'Sunday' else

...

Appreciate your reply, and it's a good idea, but the Supervisors don't want it segregated by rep - they need their whole team.

Thanks for this, but I don't use an SP - it is a simple select statement.

Kingston,

I feel like I owe you my firstborn!! Can't thank you enough for this, worked like a charm!!!

You guri know your stuff. I should have known it was...

Perfect,

Thanks very much Burninator!