SSRS 2005 Calls My Stored Procedure 3 times
-
I have a SSRS 2005 report that calls a stored procedure 3 times (viewed in profile trace) when it is only explicitly called by me through the report once. I have yet to find anywhere in my reporting solution where this is occurring, but SQL profiler tells me that it definitely is. Please help!
-
Can you post the Profiler results?
Are you seeing this behavior on a deployed report or in BIDS?
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 -
I cannot post the profiler results but there are definitely 3 rpc completed tasks in it for the procedure call when I run the report through BIDS. The report runs numerous subreports, so the rpc completed tasks in profiler for those procedures follows the 3rd call of the original procedure.
-
Are all the calls on the same SPID?
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 -
Yes, all the calls for this report on are the same spid... the 3 calls for the main procedure and the subsequent calls for the subreports.
-
Hmmm. I did some testing here with a main report and 1 subreport ans I only see one RPC:Completed for the stored procedure in the main report. The report isn't calling the the SP multiple times to also populate parameter drop-downs is 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 -
No dropdowns. The report only has one dataset tied to the procedure in question. The results from that dataset are used as parameters for the subreports. Do you know of a way in BIDS where I can see the "execution plan" for the report?
-
You may want to open the rdl file (in xml format) in a text editor and do a search on "DataSourceName" or dataset, etc.
Regards,
William S.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply