I make a relation with below code:
Code: Select all
var reportEquipmentsDataSource = new Stimulsoft.Report.Dictionary.StiDataTableSource();
reportEquipmentsDataSource.name = "reportEquipmentsDataSource";
reportEquipmentsDataSource.alias = "reportEquipmentsDataSource";
reportEquipmentsDataSource.nameInSource = "repairRequestDetailsReportDataSetObject.reportEquipmentsDataSource";
var reportReapirRequestsDataSource = new Stimulsoft.Report.Dictionary.StiDataTableSource();
reportReapirRequestsDataSource.name = "reportReapirRequestsDataSource";
reportReapirRequestsDataSource.alias = "reportReapirRequestsDataSource";
reportReapirRequestsDataSource.nameInSource = "repairRequestDetailsReportDataSetObject.reportReapirRequestsDataSource";
report.dictionary.synchronize();
var MyRelation = new Stimulsoft.Report.Dictionary.StiDataRelation();
MyRelation.dictionary = report.dictionary;
MyRelation.name = "MyRelation";
MyRelation.alias = "MyRelation";
MyRelation.nameInSource = "MyRelation";
MyRelation.parentSource = reportEquipmentsDataSource;
MyRelation.childSource = reportReapirRequestsDataSource;
MyRelation.parentColumns.push("EquipmentId");
MyRelation.childColumns.push("EquipmentId");
MyRelation.isCloud = false;
report.dictionary.regRelation(MyRelation, false)
report.dictionary.regRelation(MyRelation, true)
report.dictionary.relations.list.add(MyRelation);
Please help
thanks