Is there anyway to identify if an FEX is being drilled to or from through any kind of reporting?

The being drilled to is part of the URL that is created from the drilldown portion of the stylesheet. This is what you see when you hover over a link that can be used for drilldown where it says IBIF_ex=fexname. also identifies the domain, when there is one.

As for the fex being drilled from, you would have to program that explicitly by passing a parm (&var) in the drilldown that identifies the calling fex.

Kathy,

Guessing that you are using a 7.6.x release - please update your profile so we don't need to guess - you can run an "Impact Analysis" on a stand-alone procedure from the Reporting Server Console -> Procedures.

Right click on the procedure name and select "Impact Analysis" this will tell you if the procedure is called by any other procedure in your APP PATH.

Not sure if there is a similar search for Managed Reporting.

Cheers

Stu