I retrieved a DataSet from the database with multiple tables, and defined the relationships between the tables. When I bind the DataSet to the Tree, the relations show-up as nodes in the Tree hierarchy. How can I hide these relations.
For example, instead of:
Tom Harden
InvoiceRelationshipName
1 $500
2 $450
I would like:
You can't skip a level of the data hierarchy, so unless there is a DataRelation defined between the data in the which the invoice records reside and the one in which the names of people reside (e.g., "Tom Harden"), you can't. You should be able to use a SQL query to create a DataSet with one table that has the people's names and another with the invoice records, and define a relation between them, in effect skipping the "InvoiceRelationshipName" in the example given above.
Note that the UltraTree.ColumnSettings.ShowBandNodes property allows you to hide the label nodes that are created for "bands", but I don't think that will help you here.
I'm not trying to skip a level in the data hierarchy. I have two tables in the example: Customer and Invoice, and I've created a DataRelation between the two tables: InvoiceRelationshipName. I'd like to hide the band created by this relationship.
The ShowBandNodes property only has two options: OnlyForSiblingBands and Always. Neither seems to hide the relationship bands.