Drill Down Path [RS]

[nilesh_tiwari]

When we drill down in a Report, in normal circumstances we are unable to trace the path from where we have drilled down.

But if we want to know the complete drill down path for a query how can it be done.

even if we can see it in a text item from where we have drilled down then too my task would be complete.

for example if in a text item we can display Camping Equipment -> Sleeping Bags, when I drill down from camping equipment (product line ) to sleeping bags (product type).

Please help me out.

[cognosjon]

I think I'm right in saying that at present you cannot display the drill path if you are using DMR or OLAP, if however you are not using these and are simply drilling through to underlying reports then just display the parameter that you are using to drill through on the report. Do this using a 'Layout Calculation' and select the required parameter.

You could concatantate these where several drill throughs have occurred to provide a trail.

[holografix]

Hi mate, if you're still looking at how to show the path have a look at this:

https://www-304.ibm.com/support/docview.wss?uid=swg21470373&wv=1