FlexCelReport.AddRelationship Method
Overloads
- FlexCelReport.AddRelationship(String, String, String, String)
- FlexCelReport.AddRelationship(String, String, String[], String[])
FlexCelReport.AddRelationship(String, String, String, String)
Adds a relationship between two tables. Note that if your tables are datasets, or come from Entity Framework, or your master detail tables are nested, you probably don't need to call this method. FlexCel will detect the relationships automatically and use them. This method is only for when you have custom data with no DataRelationships (as in a dataset) and where detail tables are not nested to the master (as in Entity Framework).
Remarks
You might use this method before adding the tables with AddTable. Tables must exist when running the report, not when adding the relationship.
Syntax
Namespace: FlexCel.Report
public void AddRelationship(String masterTable, String detailTable, String masterKeyFields, String detailKeyFields)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
masterTable | String | Master table for the relationship. | |
detailTable | String | Detail table for the relationship. | |
masterKeyFields | String | Key fields in the master table that relate with the key fields in the detail table. Must not be null, and normally will be an array with a single field. It must be the same length as detailKeyFields/> |
|
detailKeyFields | String | Key fields in the detail table that relate with the key fields in the master table. Must not be null, and normally will be an array with a single field. |
See also
FlexCelReport.AddRelationship(String, String, String[], String[])
Adds a relationship between two tables. Note that if your tables are datasets, or come from Entity Framework, or your master detail tables are nested, you probably don't need to call this method. FlexCel will detect the relationships automatically and use them. This method is only for when you have custom data with no DataRelationships (as in a dataset) and where detail tables are not nested to the master (as in Entity Framework).
Remarks
You might use this method before adding the tables with AddTable. Tables must exist when running the report, not when adding the relationship.
Syntax
Namespace: FlexCel.Report
public void AddRelationship(String masterTable, String detailTable, String[] masterKeyFields, String[] detailKeyFields)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
masterTable | String | Master table for the relationship. | |
detailTable | String | Detail table for the relationship. | |
masterKeyFields | String[] | Key fields in the master table that relate with the key fields in the detail table. Must not be null, and normally will be an array with a single field. It must be the same length as detailKeyFields/> |
|
detailKeyFields | String[] | Key fields in the detail table that relate with the key fields in the master table. Must not be null, and normally will be an array with a single field. |