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?
It is not possible for rows of different levels to wrap into each other, the closest you can get is the following;
But that's exactly what I am trying to do as illustrated in my initial email. I want to be able to show the higher-level Order data and the Item data in the same set of rows so that the Order Comments that you mentioned and other Order level fields will wrap as far into the rows beneath as necessary. Again it would look something like:
Hi Jerry,
Yes, you can make a report with hierarchical sections and/or tables to represent your data.
You can look at the Nested Sections and Hierarchical Table sample, and the following help topics:
Note: the Order Comments will make the rows grow, but rows will not overlap with each other.
Let us know if you have any questions!
Regards,Héctor