Hierarchical Report with more tables in relations

[info@2next.it]

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.

ExampleHierarchical.mrt

(8.78 KiB) Downloaded 146 times

Hierarchical DB sqlexpress 2012.zip

(296.68 KiB) Downloaded 169 times

The final report (I used the value of db attached) would be like this:

Immagine senza nome.png (27.29 KiB) Viewed 1683 times

thank you very much for your time

[Alex K.]

Hello,

Sorry, maybe we did not exactly understand your task.
You can use the Master-Detail-SubDetail-SubSubDetail construction.

Thank you.

[info@2next.it]

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.

Data.png (302.79 KiB) Viewed 1666 times

With records saved in tables on image above and show only product with id 8 the report should be:

result.png (9.97 KiB) Viewed 1666 times

How you understand... the levels depends of records and are not fixed...

SimpleExampleHierarchical.mrt

(7.05 KiB) Downloaded 168 times

Hierarchical_product_compo_sqlexpress2012.zip

(300.24 KiB) Downloaded 139 times

thank you
2next

[Alex K.]

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.