Thank for this. The total are right but not the format. The reesult I need it to be:

year, month_no, month,opened, closed.

2009,1,January,200, 204

2009,2,February,100,95

Thanks

GReg

Thanks Seth, This works , BUT the problem is that the closed totals are a little out and it because the opened date could be in a previous month but...

Thanks for your reponse

Yes I did manage to sort this out. I needed to add the windows group "Windows Authorisation Access Group" to the user account that Reporting Services is...

Thanks for the reply and solution. It worked for me - Much appreciated

Regards

Greg

Jeffry, Thanks for your help. I think I have this sorted. I used this and it has worked. Would just like to replace the word NULL with '' but the...

Thanks Jeffry. I have changed the script to be:

SELECT ufi_id,ufi_class,ufi_status, [ACCEPTDATE], [ADDRESS1],[ANNDEPR],

, [AREAHA], [AREAM2], [ASBUILT], [AVEHEIGHT], [BANKSLOPE], [BLIFEVALUE], [CCTV], [CCTVDATE], [CLASS], [COMMON], [COMPLEXITY],

[CONDAS], [CONDITION], [CONSENTEXD], [CONSENTISS], [CONSENTREF], [CONSENTVAL],...

Thanks for the reply guys, much appreciated. Soory but I have been away for a while. I have tried the pivot query,

SELECT ufi_id,ufi_class,ufi_status, [ACCEPTDATE], [ADDRESS1],[ANNDEPR],

, [AREAHA], [AREAM2], [ASBUILT], [AVEHEIGHT],...

Thanks for all your help guys. Much appreciated.

Greg

Cheers NewBie

This worked but did leve and entry from 31/08/06 @ 9am

Greg

Thank for this

I get this error in QA

Server: Msg 245, Level 16, State 1, Procedure CleanWho'sOutList, Line 10

Syntax error converting the varchar value '6:15 a.m. ' to a column of...