data relation problem

[Ehsan]

Hello dears

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);

but it doesn't work

Please help
thanks

[Alex K.]

Hello,

Could you explain your issue in more details?
Also, please show code which adds your data sources (reportEquipmentsDataSource, reportReapirRequestsDataSource) to the report.

Also, please try to use the following code:
You can use the following code:

Code: Select all

var dataRelation = new Stimulsoft.Report.Dictionary.StiDataRelation("MyRelation", "MyRelation", "MyRelation", report.dictionary.dataSources.getByName("Categories"), report.dictionary.dataSources.getByName("Products"), ["CategoryID"], ["CategoryID"]);
report.dictionary.relations.add(dataRelation); 

Thank you.

[Ehsan]

Hello dears

Above code works,
Thakns a lot

[HighAley]

Hello.

We are always glad to help you.

Thank you.