Forum Discussion
Nested Drill Throughs
In my example below I have a summary page and a detail page. My summary is a matrix of Division Name and Member Name. On my detail page, I have only added Member Name to the drillthrough well.
If I right click on an amount for a Member Name I get the drillthrough option but if I right click on an amount for Division Name I don't.
However, if I add Division Name to the drillthrough well on the detail page I can the drill on either Member Name or Division Name.
Aha! Such a deal!
I didn't realize I had to put the field from the parent report in each of the children; I figured it was only needed for the first drill through.
Excellent! Well, not totally, my second level child report isn't showing the data from the first level child (its parent), but I am getting the drillthrough option in the context menu, now, so that's an improvement.
Thanx, JD!
Super UserIn my example below I have a summary page and a detail page. My summary is a matrix of Division Name and Member Name. On my detail page, I have only added Member Name to the drillthrough well.
If I right click on an amount for a Member Name I get the drillthrough option but if I right click on an amount for Division Name I don't.
However, if I add Division Name to the drillthrough well on the detail page I can the drill on either Member Name or Division Name.
Aha! Such a deal!
I didn't realize I had to put the field from the parent report in each of the children; I figured it was only needed for the first drill through.
Excellent! Well, not totally, my second level child report isn't showing the data from the first level child (its parent), but I am getting the drillthrough option in the context menu, now, so that's an improvement.
Thanx, JD!