Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
650
Hierarchical data grouping within a single table
posted

Have some hierarchical data that I have been trying to format in a specific manner and have not been able to get a report layout to display it in the manner I am attempting. I have two-level hierarchical data, say an Order which contains multiple Items. What I would like to do is display the data in this way:

| Item columns           | Order columns                           |

ProductId Quantity Price OrderDate OrderComments

1            1           10.0  3/1/2013  Customer has asked

2            2           21.5                 for expedited delivery.

3            7           3.75

3            3           10.2  3/1/2013  Products not in stock as

4            2           17.3                 of 3/1. Will backorder

                                                  and let customer know.

Where I am showing both the Order and Item data on a single line, and the Order data wraps into additional rows as needed. The Item level records start on the same line as the Order level record and takes up as many rows as is needed to show all Item records.

Is there any way to represent hierarchical data in this way using NetAdvantage Reporting?

Parents Reply Children