Welcome Guest! To enable all features please Login or Register.



Go to last post Go to first unread
#1 Posted : Friday, November 8, 2019 5:59:19 AM(UTC)

Rank: Advanced Member

Groups: Registered
Joined: 8/9/2019(UTC)
Posts: 45

Thanks: 13 times
Hi Eric,

Please confirm that When we do a drill-down, shouldn't the report ideally show the next level of detail, with the same filters applied in the background ?

Ex: in Northwind, I have drill-down enabled on Customers.City (drill down to --> Customers.Customer).
This is pulled into my report along with fields : Customers.Customer and Order_Detail.Amount.

On clicking City-A (which displays Amount=$100), I would expect to now show me the customers that :
i.) pertain only to City-A
ii.) contribute to afore-mentioned $100 Amount.

- But it instead shows me ALL the Customers under City-A.
-And If I click on the 'Information' tab , the Restriction is shown as : City='A'; instead it should have been City='A' AND Amount=100 .

For a temporary workaround, I have pulled "Amount" field as a Row-Element, declaring the drill-down on it too. So now the 'Information' tab shows Restriction: Amount=100, with the correct drill-down data.

Could you please tell me if I have missed out on any step to achieve drill-down accurately ?

Thank you.
#2 Posted : Friday, November 8, 2019 6:57:08 AM(UTC)

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 936

Thanks: 14 times
Was thanked: 159 time(s) in 153 post(s)
The drill restriction will be applied only to the parent element drilled as explained here:

The problem here is when you have several lines with City-A, the other values of the line will be taken into account, this is not handle by the drill mechanism so far.

could be a feature request and added as an option of the drill.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.