Hello,
I don't know how I can build this report. I have 4 table in relations. The levels are: Product-->Phase-->Process-->Material. The product has one or more phases that has one or more process etc...
On Material there is a relation on Phase that collect the tree structure. So Material use a Phase record and is child of Process.
This report could have more levels, is nested and depending of data the number of levels...
The report should be use Phase table or query in hierarchical mode... but I Have more tables and the Key Master is on other Table (Material).
Can you help me?
I build the dictonary into the report I attached to facilitate your task.
The final report (I used the value of db attached) would be like this:
thank you very much for your time
Hierarchical Report with more tables in relations
-
- Posts: 18
- Joined: Tue May 24, 2016 11:10 am
Re: Hierarchical Report with more tables in relations
Hello,
Sorry, maybe we did not exactly understand your task.
You can use the Master-Detail-SubDetail-SubSubDetail construction.
Thank you.
Sorry, maybe we did not exactly understand your task.
You can use the Master-Detail-SubDetail-SubSubDetail construction.
Thank you.
- Attachments
-
- Capture.PNG (47.98 KiB) Viewed 1666 times
-
- Posts: 18
- Joined: Tue May 24, 2016 11:10 am
Re: Hierarchical Report with more tables in relations
Hello,
thanks for your answer...
Are nested data, not fixed master-details... in your report result when show Completed product-->Phase last-->Process Last... below would be show the Product ONE node... depending on data...
I undertand the complex. So Look this more more simple example:
2 Tables, Product is table products. Compo is table that has a Parent Product and a child Product. So the levels in theory colud be infinite and depend on Records. With records saved in tables on image above and show only product with id 8 the report should be: How you understand... the levels depends of records and are not fixed... thank you
2next
thanks for your answer...
Are nested data, not fixed master-details... in your report result when show Completed product-->Phase last-->Process Last... below would be show the Product ONE node... depending on data...
I undertand the complex. So Look this more more simple example:
2 Tables, Product is table products. Compo is table that has a Parent Product and a child Product. So the levels in theory colud be infinite and depend on Records. With records saved in tables on image above and show only product with id 8 the report should be: How you understand... the levels depends of records and are not fixed... thank you
2next
Re: Hierarchical Report with more tables in relations
Hello,
Unfortunately, with such a structure tables, it is not possible to create a hierarchical structure in the report with standard ways.
In this case, you need to prepare the additional data source.
Thank you.
Unfortunately, with such a structure tables, it is not possible to create a hierarchical structure in the report with standard ways.
In this case, you need to prepare the additional data source.
Thank you.