question

don 2 avatar image
don 2 asked

SSRS and SQL Profiler

Hello, I’m having trouble with an SSRS report (not retrieving the data that I expect) so I thought SQL Profiler could show me the SQL that is being executed.

Here’s my issue: I have three datasets: the first is a straight SQL, the second is a SQL statement with a parameter (where PLAN_TYPE=left(@parm_PlanType,2), and the third is a SQL statement with a multi-value parameter ( where BENEFIT_PLAN in (@parm_BenefitPlans)).

Here’s my problem: The only SQL statement that I ever see in SQL Profiler is the first one. Does anyone have any idea as to why the SQL statements with parameters don’t show in Profiler?

I've been using primarily SQL:StmtCompleted

Thanks in advance for your help. - DF

ssrsprofiler
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered

When you say you are using parameters, are you passing these to stored procedures?

If you are you may need to include RPC:Starting or RPC:Completed events.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.