Creating reports and dashboards | Stimulsoft community forum

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

Hello,

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

Thank you.

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

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.