Following is the sample of hierarchy table that I setup. Also, follows is the modified master file for this table that I changed to reflect the hierarchy. However, when I drop in some fields in the report painter and switch Child2 field to ‘For’ and click the matrix tab, I get the following error "Top element missing. Would you like to display a data tree anyway?". If I click Yes, then it only shows a few rows from Child1 and Child2 columns. What seems to be wrong here? Thanks!

Parent Child 1 Child 2 Caption
100 411 411100 Gross Sales
100 411 411600 Gross Sales
100 4111 411700 Less Discounts and Allowances
100 511 511100 Cost of Goods Sold
100 5111 511200 Rebates
100 5111 511210 Rebates
100 5111 511220 Rebates
3000 3033 6111000840 Salaries No Print
3000 3033 6112000840 Salaries No Print
3000 3033 6113000840 Salaries No Print


FILENAME=glheir, SUFFIX=SQLMSS , $
SEGMENT=GLHEIR, SEGTYPE=S0, $
FIELDNAME=PARENT, ALIAS=PARENT, USAGE=A6, ACTUAL=A6, PROPERTY = PARENT_OF, REFERENCE = CHILD1, $
FIELDNAME=CHILD1, ALIAS=CHILD1, USAGE=A7, ACTUAL=A7, PROPERTY=PARENT_OF, REFERENCE = CHILD2, $
FIELDNAME=CHILD2, ALIAS=CHILD2, USAGE=A10, ACTUAL=A10, $
FIELDNAME=DESCRIPTION, ALIAS=DESCRIPTION, USAGE=A30, ACTUAL=A30, PROPERTY=CAPTION, REFERENCE=CHILD2, $

This message has been edited. Last edited by: Kerry,

The Parent of the top node must be blank.

I am not sure if I follow. Could you modify the example code shown above to give an idea how to leave the parent blank? Thanks.

You can't have 2 children on the same row... your mfd (and data) needs to be more like this:

FILENAME=glheir, SUFFIX=SQLMSS , $
SEGMENT=GLHEIR, SEGTYPE=S0, $
FIELDNAME=PARENT, ALIAS=PARENT, USAGE=A6, ACTUAL=A6, PROPERTY = PARENT_OF, REFERENCE = CHILD1, $
FIELDNAME=CHILD1, ALIAS=CHILD1, USAGE=A7, ACTUAL=A7,$
FIELDNAME=DESCRIPTION, ALIAS=DESCRIPTION, USAGE=A30, ACTUAL=A30, PROPERTY=CAPTION, REFERENCE=CHILD1, $