How to make report with 4 levels of data
I don't know how I should make the next report:
First I have a master record which is always 1 record. It is a product with his property's like: product name, price, productnumber, ect..
For the first level I use a ClientDataSet which is "memory based".
Then I have the second level which could have several records. It is the product groups. Thus one product could be connected to several product groups.
For the second level I use a ClientDataSet which is "memory based".
Then I have the third level which could have several records. It is information of the last advertising of the product. For the third level I use a ClientDataSet which is "memory based".
Then I have the fourth level which could have several records. It is information of the last demonstration of the product. For the fourth level I use a ClientDataSet which is "memory based".
I hope everything is clear.
Could anybody tell me how I can make this?
According to me there is only support for 3 levels of data or am I wrong?
First I have a master record which is always 1 record. It is a product with his property's like: product name, price, productnumber, ect..
For the first level I use a ClientDataSet which is "memory based".
Then I have the second level which could have several records. It is the product groups. Thus one product could be connected to several product groups.
For the second level I use a ClientDataSet which is "memory based".
Then I have the third level which could have several records. It is information of the last advertising of the product. For the third level I use a ClientDataSet which is "memory based".
Then I have the fourth level which could have several records. It is information of the last demonstration of the product. For the fourth level I use a ClientDataSet which is "memory based".
I hope everything is clear.
Could anybody tell me how I can make this?
According to me there is only support for 3 levels of data or am I wrong?
Comments
After your 3rdt level band, you add a child band. Of course, your 3rd level data band point to this child band.
And in this band you just add a SubReport.
Then you design your nex dataBand Level (4) in the subreport, an so on ....