Is there a way to Drill Down with Union Sub Query?
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?
The same question
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
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
Hello David,
That's what I am trying to avoid to create multiple reports.
Can this request be logged as an Idea?
Regards,
Abhay
Hello David,
That's what I am trying to avoid to create multiple reports.
Can this request be logged as an Idea?
Regards,
Abhay
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
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
Thanks for considering this as an idea.
Thanks for considering this as an idea.
Hi Abhay,
you're welcome!
regards,
David
Hi Abhay,
you're welcome!
regards,
David
Replies have been locked on this page!