Is there a way to Drill Down with Union Sub Query?

Abhay Bagalkoti shared this question 3 years ago
Answered

I have a report with multi level union sub query and the hierarchy is similar in all queries.

They differ in underlying data.


The drill down option doesn't show up when Union is used.


Is there way to use it or it is a defect?

Comments (5)

photo
1

Hi Abhay,

it is not a defect. The Drill-Down feature is not supported for the Union sub-query.


However, you should be able to get the same sort of functionality by using the Drill Through. For example:


1) a parent report has 2 fields, Country and Population, and is enabled for Drill Through.

2) the child report has a user input filter that is the same field that is the top of the drill-down hierarchy, in this example "Country". And it has 2 fields: City and Population

3) in the Related Reports section of the report builder, the parent report's Country field is the Master Field that is linked to the child report's Country filter.


I hope that makes sense and helps you meet your reporting requirements!


regards,

David

photo
1

Hello David,


That's what I am trying to avoid to create multiple reports.

Can this request be logged as an Idea?


Regards,

Abhay

photo
1

Hi Abhay,

OK, I understand, I guess I was just offering that suggestion as a workaround rather than a solution!

I have just raised new Idea 4254 for you.

regards,

David

photo
1

Thanks for considering this as an idea.

photo
1

Hi Abhay,

you're welcome!

regards,

David