Thanks very much Elliot all points duly noted. One question though what are you using for source control?

Thanks Elliot for your response. I would be actually moving the development to the actual dev machine. The machine I am using now is just in the interim...

Thanks for your response. I am actually doing development on another machine because the dev machine has not been purchased as of yet but we are expecting to have...

Thanks for all your input much appreciated.

So the following script is what I have so far to attempt accessing the data:

EXEC sp_addlinkedserver 'OracleSvr',

'Oracle 7.3',

'MSDAORA',

'ORCLDB'

GO

SELECT...

My guess is this functionality can not be done in SSRS so the implementation of a .Net solution for parameter input appears to be the solution of choice. Thanks...

As I haven't got a response yet let me be a little more specific in my question can you have tool tip like selection completion prompts as in a Google...

Thanks for all your answers this is making it much clearer. I am currently reading Microsoft SQL Server 2008 MDX which is also making things easier to understand. ...

Ok I am trying to wrap my head around the usage and need of MDX code. I was thinking that MDX was used simular to T-SQL to extract data...

I was wondering Amit if you know if MDX code can be saved as stored procedures which can be called or are they stored in some other fashion to be...

Cheers

Thanks I have so much too learn.

Thanks again.

Hi Amit,

How exactly do I extract the MDX code from the SQL Profiler.

Thanks,

Great thanks Amit much appreciated

Thanks