January 11, 2012 at 12:45 pm
I am getting error in one of the report and need to see the full query used in dataset on the report.
query has in clause and one of the parameter is username so not sure if that is causing the issue.
Is there a way to see the entire query that is passed to database on the report.
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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply