Queries for child pararameters not visible in profiler
Hi Folks Good Morning/Evening I have a ssrs report that is built on sql server 2005. It has some input cascading parameters meaning a parent parameter and 2 child parameters. For example when you select USA as country (parent parameter) then some states and sub states populate into child parameters - State and SubState. I had some problems with the queries for child parameters, so ran a trace inside sql server and could only see the query for a parent parameter and no query for child parameter . I was running the report in report manager. Is this behavior normal?
Tried to simulate this evening and to my surprise it is showing in trace results in the form of dynamic query i.e. exec sp_executesql. event class - rpc completed application name - .net sqlclient data provider Sorry for the confusions (may be a security limitation) and thanks for suggestions. How should I close this question?