solved it

there is a newer version (content created 29/8/12) of DB2OLEDBV4 kicking around that works

well...you can

=SUM(F2:F6*1)

or

=SUM(VALUE(F2:F7))

all you have to do it convert to a number from text in the formulae

many thanks, it's there cheers

I think the answer to my question of temp table scope is...

there's no cross over if the table begins with #

but global temp tables beginning with ## exceed the session

and...

the object stated in the error

[ADO NET Destination Input].[TempDistributor1]

i take it it's a Data Flow task...check the properties of the destination

which bit fails in debug?

check the properties of your object for a timeout property, it's probably set to 60 seconds, set it to 0

i solved this by changing the dataset of the report, adding a WHERE clause in the SQL and putting the parameter in there

where somefield in (@ParamList)

sort of thing

that's it!

she was on Google Chrome

now I've tried installing Chrome here in London and it's forbidden, so I'm not sure how she's done it in New York, but she has,...

anthony.green (6/27/2012)

---

No remote errors display in the webpage of SSRS. So instead of it saying Error cannot connect, it gives more details as to why it cannot connect for...

anthony.green (6/27/2012)

---

Any particular error messages? What exactly is not working for B that is working for A? Do you have remote errors enabled on the SSRS server to...

actually, think I found a solution

http://www.codeproject.com/Articles/32151/How-to-Use-a-Multi-Result-Set-Stored-Procedure-in

this isn't really solving your problem...

but I use "localhost" as the database name in my SSAS processing tasks...

you'll need to get the right entry in your tnsname.ora file once Oracle is set up

if you set up something in your tnsnames.ora, say "BIGDB"

you can, in MSDOS, do

tnsping BIGDB

which...

if you can change the spreadsheet, add a worksheet with 5 columns and formulae in them to look up the other sheet and fill in the other columns with dummy...

depends if your business logic is EVER going to change