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