January 12, 2012 at 8:52 am
You can see the query in the report definition. If you don't know where the original report definitnion is you can download it from the report server and edit it. Another option is to run Profiler as you run the report and you can find the queries being run by it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 12, 2012 at 9:04 am
Also, if this is SSRS 2005, then you should be able to run the report from within SSMS when connected to that SSRS instance. It will give you a better error that will help in troubleshooting the problem.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply