Thanks for getting back

I tried ..=sum(reportitems!Textbox9.Value)

but getting the error Aggregate functions can be used only on report items contained in page headers and footers

thanks for the info, its 2008, but I used the Create linked report, worked great and easy...

I can even remane it!! lol

I guess I got a bit or reading...

Hi MDJ..

Thanks for the info, yes yours works and I added some logic etc and I'm getting output for a SSRS report..

Still get the "squiggly" but working.

While I'm here..

I think...

sorry left out a big part these are views

it can't becuase it has a shared datasource

Thanks Sean

Sorry made it more complicated than it was definitely should be using aliases there are lots of tables in the DB with similar and weird names...

Thanks

so what I need to do is update the client_identifier table based on the client ID on the client table with a link table in between..

so my spreadsheet looks like

clientID...

Sorry

This makes no sense...

What I am trying to do is

if ID = '123' CLient Table

set Identifer to 'xx123' if the identifer = 'xx233'

my ss looks like :

clientID ...

I guess you'd be all set if you were ambidextrous...

Thanks Sean.. good idea

Its one thing I think I do get..

At least I think I do.. lol

Thanks so much.. wow I have sooo much to learn...

never thought of using an on with more than one field...

Thanks so much....

I bit of a brain crap ... or just being a SPAZZ!!

I was testing with

DECLARE @Date varchar(8)

set @Date='Jul 24 2013 8:05AM'

SELECT CONVERT( datetime, @date)

select cast(cast('Jul 24...

If it helps Im looking or something like =count(ReportItems!Textbox72.value)

but getting an error athat arregate function can only be in header and footers

Thanks Chris,

That work great..

Now I have to do some reading so I know exactly what this is doing... lol

I really appreciate the time.....

Hope the weather is as nice in London...

Hi Chris,

yes tried like this ..

SELECT

ASSESSMENT_DATA,

start.pos,

[end].pos,

SUBSTRING(ASSESSMENT_DATA,start.pos,[end].pos-start.pos) as ss

FROM USER_DEFINED_DATA

CROSS APPLY (SELECT pos = LEN('@@T_700_ = ') + CHARINDEX('@@T_700_ = ',ASSESSMENT_DATA,1)) start

CROSS APPLY (SELECT pos = 1+CHARINDEX('"@@T_301',assessment_data,start.pos)) [end]

WHERE...