Page 1 of 1

data relation problem

Posted: Tue Jul 18, 2017 12:42 pm
by 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

Re: data relation problem

Posted: Tue Jul 18, 2017 10:48 pm
by 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.

Re: data relation problem

Posted: Wed Jul 19, 2017 6:20 am
by Ehsan
Hello dears

Above code works,
Thakns a lot

Re: data relation problem

Posted: Wed Jul 19, 2017 11:03 am
by HighAley
Hello.

We are always glad to help you.

Thank you.