Hi All,
I hope someone can suggest a solution. I have 2 tables that I am trying to join in an interactive report and have a tree like structure. The table are set up like the following:
Table tools - TOOL_ID, TOOL_NAME, TOOL_DESCRIPTION
Each tool can be connected to many parts:
Tool to Parts table - PART_ID, TOOL_ID
Ideally the report that I want will show the tools data with the functionality to drill down to display the parts that are associated with that tool.
I could create another report region on the page to pass the tool_id to as a parameter and display the tool_to_part data based on that but then I will lose the functionality that comes with the interactive report (only one interactive report per page). A tree region wont give me the functionality that comes with an interactive report either allowing me perform searches on etc.
The report that I would like would something like:
+Tool ID Tool Name
Part A
Part B
Part C
where the parts data can be collapsed with the '+'
I am using APEX v4.0
Thanks
Chris