DataSource

satisht · Post by **satisht** » Thu May 17, 2007 4:45 am

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.

Post by **Vital** » Thu May 17, 2007 8:50 am

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.

satisht · Post by **satisht** » Fri May 18, 2007 12:02 am

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?

satisht · Post by **satisht** » Fri May 18, 2007 12:18 am

Or should I send .mrt file to support?

Post by **Edward** » Fri May 18, 2007 2:02 am

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

.

Thank you.

satisht · Post by **satisht** » Wed May 23, 2007 11:52 pm

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

Post by **Edward** » Thu May 24, 2007 3:27 am

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.

satisht · Post by **satisht** » Thu May 24, 2007 5:06 am

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?

Post by **Edward** » Thu May 24, 2007 5:39 am

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.

satisht · Post by **satisht** » Fri May 25, 2007 1:21 am

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.