Creating reports and dashboards | Stimulsoft community forum

I am having 2 tables I have tried to add the table in report dataset but I found it difficult , can we add the table in report dataset and how? if not how should I have provide the 2 tables to report dataset.

Report does not have special DataSet for data. You can use method RegData of report to register DataSet or DataTable to report. For also you split two DataTable into one DataSet if you set property CacheAllData of report in report designer. In this case all report data source will be merged in one DataSet. You can use this mode when you need create relations between DataTAble which placed in different DataSet's or from different databases.

Thank you.

I am having 2 tables in different datasources as you have told ,I have set property 'CacheAllData' of report in report designer and i have passed my 2 tabled dataset using regdata but still it is not using sencond datasouce to register second data souce is there any another way? How should i register both tables in different datasouces?

Or should I send .mrt file to support?

Ok, please send a mrt file of your report and a code which is used for registering a data to .

Thank you.

Yes I have sent the .mrt file to the support dot stimulsoft.com

satisht wrote:I am having 2 tables in different datasources as you have told ,I have set property 'CacheAllData' of report in report designer and i have passed my 2 tabled dataset using regdata but still it is not using sencond datasouce to register second data souce is there any another way? How should i register both tables in different datasouces?

The best way in case if you need to create relation between DataSources from different datasets is setting Report.CacheAllData = true. You can access this property in the PropertyGrid in the Designer. After that you can create relations between DataSources from different sources.
Another way is prepare one dataset in your program and register all your tables in a report at once.

Thank you.

As you have told, I have made CacheAllData property true , but still i am facing problem that report is not get registered with both tables in different datasouces. There are 2 tables in different datasources. I have created a dataset with 2 tables and trying register this dataset to report but only first table get registered! How to register both tables of both datasouces?

satisht wrote:As you have told, I have made CacheAllData property true , but still i am facing problem that report is not get registered with both tables in different datasouces.

CacheAllData property guarantees only that Relations could be created between DataSources from different Connections. This property doesn't manage the DataName property during registering datatables.

satisht wrote:There are 2 tables in different datasources. I have created a dataset with 2 tables and trying register this dataset to report but only first table get registered! How to register both tables of both datasouces?

To register DataSet instance in the report Dictionary you need add the name to this dataset while its creation or to assign it in RegData(NameOfTheConnectionInReport, dataset) method of the report.
If you need to have different DataSources in the report Dictionary under the same Connection, please merge all your data in one DataSet and then register it via RegData(NameOfTheConnectionInReport, dataset).

Thank you.

Hi i have tried to register the both tables but it was not worked , I have tried to register both datasouces by

Report.RegData("NewDataSet", dataSet)
Report.RegData("Data from DataSet,DatTables", Table2)

But still 2'nd dataseet is not get registered.