Thanks Jeff,

maybe I should have mentioned the client only has SQL Express 2012. I...

Thanks Luis

Thanks Tom, using the CTE worked for me

Thanks PietLinden & Jeff, I had been looking at the PIVOT but most examples seemed to expect you to know the name of the columns you were going to get...

Thanks, the binary tree approach is what I am using but was really hoping there would have been a faster method.

I still haven't solved this. Anyone have any ideas?

Thanks, but no Active Directory involved. These are standalone PCs (the one giving trouble is running Vista Home Premium!). I use LogMeIn Hamachi to provide a VPN between...

Sorry for the slow response. Yes I did solve it, it's been so long I can't remember the exact problem and solution, but I can give you, or anyone...

Thanks I had actually found a book and bought it hoping that it would help me despite it being for VS 2005 and thankfully it did.

This is the book:

Unfortunately I'm still not getting it.

I am using Visual Studio 2010 and have created an RDLC main report and subreport.

Can you recommend a good walk through or...

Thanks, I'll see if I can get that to work

Has this never been done before?

Frank Cazabon (2/26/2013)

I am adding a subreport to a report and I need to pass a uniqueidentifier or Guid to the subreport. However the...

Thanks Steven & Lowell, that helped. I didn't quite use your queries but I adjusted my query (stored procedure actually) to do the totalling for me.

Thanks again. I just started trying that and found that there is no jobs folder under my sql server installation!

At this stage I'm thinking I need to reinstall.

< later...

I changed the account for the service from the SQL Server Configuration Manager.

Everything works if I use my administrator account. But I think this is a bad idea so...