Don't think we are talking about the same thing.

I can connect OWC to an OLAP cube, quite easily, and manipulate the data. What I am trying to do is click...

Thanks for that - I actually am querying it in SQL server (linked server), with the intention of using it in a stored procedure.

sounds like this is not possible...

Hi Cherie,

I am part of a small consultancy in the UK, specialising in Microsoft BI. We certainly have strong reporting services expertise, as well as delivering solutions encompassing the full "suite"...

syscomments should hold the script for all procedures. Maybe consider doing query against all stored procs, and finding those that don't have certain keywords that you might require e.g. "with(nolock)"....

Sounds like you should be using an analysis services cube for this, instead of reporting services. You have a choice of client interfaces over the cube - you can use...