I had a similar poor 'customer care' experience with Dell. I eventually wrote a letter to the Chief Executive and received no reply. It felt as though they held their...

Thanks for the info Chris, it's much appreciated,

cheers,

dom

Hi Chris,

thanks for the help, I've fathomed it out now! I'm not that familar with CTE's, so it'll be something I'll read up on in the next day or two.

regards,

Dom

I'm sorry Chris but I don't follow how your code works.

regards,

Dom

SELECT FileNM FROM CADlist

-----

UPDATE CADlist

SET FileNm = REPLACE(REPLACE(fileNm,'Floor Plan',''),'CYP','')

-----

SELECT FileNM FROM CADlist

-----

UPDATE CADlist

SET FileNM = REVERSE(FileNM)

SELECT FileNM FROM CADlist

-----

If I remove 'CYP' and 'Floor...

Thanks for the response

...I'll have a play...

Hi Gift,

Thanks for the reply,

I am indeed running SSRS and will take your comments into consideration......when I get round to upgrading!

regards,

Dom Horton

Hi Gianluca,

many thanks for your reply,

I wasn't sure that a nested/sub query was the way to go....thanks for confirming that method.

regards,

dom

Thanks Doug for your valued contributions....I will look into your suggestions when I have a moment (time constraints at work are limiting me at the mo'!)

Dom

why can't you comprehend?!

.net frameworks already updated

Hi Doug,

I've eventually come back to this....tried a fresh install on another PC...Windows 2000, SQL Server 2005 SP2 Developer version. All seems to install fine.

Reporting Services Configuration - fine

PC running...

Many thanks for your help so far......I think we've narrowed it down to be firewall related...so will be in touch with our security guys.

cheers,

dom

...it all appears to be how I initially set it up....nothing appears to be missing and clicking 'Test Connection' works.

any other ideas?

thanks

thanks for the reply.....where should I look to check the connection string?

I've set up a shared datasource, and looking at the connection string there it appears to be ok.

(i've also...

Thanks Doug for sharing this with me,

I'll have a look into the comments and links you provided when I get a mo'.

regards,

dom