RonKyle (12/6/2013)
I personally find SSRS to use against MDX sources, but this isn't a problem with OLTP and standard T-SQL.
Hi thanks for the replay, is the word "difficult"missing from the above sentence, as i would agree if it is.
yes thats what i was thinking IN THE SHORT term, run reports off a restore of the current DB. I see this as giving some value to the bisness up front and would give me more time to get to grips of the business needs to provide medium & long term BI solutions weather that be Datawarehouse, Datamarts OLAP cubes.