thanks for the reply

ill be honest I often didn't see their use as even necessary as a sub query in what I saw

but even if they were there only to...

Thanks a lot for the replies, all makes sense

ok thanks a lot

proc2 is set outside the catch block, i did put it inside by mistake and editted my post, you probably saw that

i understand now anyway, thanks a...

thanks agina for the reply,

Rather than this

Begin Try

Begin Transaction T1

--exec Proc2

Commit Transaction T1

ENd TRy

Begin Catch

--Rollback Transaction T1

--insert into error table

end catch

i should perhaps look at this

Begin Try

Begin Transaction...

hi, thanks a lot for the reply

i do have error handling

my code actually looks something like this

Begin Try

Begin Transaction T1

Commit Transaction T1

ENd TRy

Begin Catch

Rollback...

Thanks mate

I was adding the parameters to the reports URL rather than the web service URL

That fixed it for me

thanks a lot

Yes I can, thanks a lot all

Luis Cazares (3/3/2015)

Koen Verbeeck (3/3/2015)

Keep in mind that you are connected live to that SSAS database.

If you...

thanks for the reply

if i do have the permissions do you know how i would open it in bids? i have a blank solution

apologies

in trying to keep it short and to teh point i forgot the mention this is in SSRS 2008 R2

yes 🙂

is it posible to put an if table exists line in your procedure?

thanks for the reply mate

i worded the first post really badly sorry.

i have come into a company who have designed a crazy part to a report, it is an image...

bump?

if there was a way to add sysusers to sysdatabases in the master database that would help?

thanks