Are you asking if you can extract from oracle then load using BCP commands? Sure...but why? Unless you don't have access to the Oracle servers I guess...

ORacle has a tool...

Are you not able to enter an expression in the visibility property of the image? What is the criteria for it to be showing?

Not easily...

If you want to do it manually you could enter the link into the 'Comments' section which accepts HTML and remove the 'Include Link' checkbox. If you wanted a...

There is a utility you can setup which reads RS Execution Logs and it comes with some predefined reports. Google it and I'm sure you'll find it...

I also have this...

Here's how I would do it:

1.) Create an sp that returns the data on a server that is setup w/ linked servers to all 3 separate instances. (Hopefully this is...

Great post Jeff...do you have a reference on Trinagular joins? I've not heard this term before but have run into the problem found in the code provided...

Cheers,

Ben

I haven't tried it before but I know when you do a MySQL backup it has an option to make the backup basically a sql script that can be ran...

Where do you want it to be displayed? You could create a log table and insert the data in there and have it for reference later...

How many pages are created when running the query? Did you try running it in the data set tab to see what all is being returned before previewing the report?

That works but I wouldn't really call it a solution to getting the field data in the header and footers...

Correct...I was under the assumption that you had a predefined username and password that was going to be used? This way I was thinking you could just add a couple...

Thanks Tim,

I've seen the /n software SSIS utilities app but the price is way outside the range for this. I have found however the open source WinSCP tool that has...

That worked for me...I don't think you can put fields in the page header or footer so this may have to go inside a textbox in the report body.

Maybe a bit of a hack but I'm thinking you could do it w/ URL parameters...

There's a system provided stored proc sp_rename that allows you to rename SQL Objects but I don't think this will work for an instance name. What did google bring back?