This is a migrated thread and some comments may be shown as answers.

2010 Q1 DataSet

3 Answers 177 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Naphtali
Top achievements
Rank 1
Naphtali asked on 15 Mar 2010, 10:41 AM
How can I use a dataset for the reports. Since until now the wizard created dataset that is what I'm using in my project, and I would not like to start using anything else. The wizard doesn't give me an option to create a dataset as of this release. If I select object datasource and then select a table adapter I created before hand the report wizard doesn't recognize the fields from the dataset.

3 Answers, 1 is accepted

Sort by
0
Svetoslav
Telerik team
answered on 16 Mar 2010, 01:53 PM
Hi naphtali davies,

Since Q1 2010 DataSet is no more the preferred type of data source object. Instead we have introduced the new Data Source Components and this is the suggested way to proceed from now on. You can still use DataSet as a data source but you should create it by yourself. As you have correctly noticed the ObjectDataSource is the way to go.

Anyway if your reports display data from a database, instead of using DataSets and DataTables we suggest using the SqlDataSource component that is designed to work especially with Telerik's reporting engine thus offering much better performance.

In order to have full design time support a typed DataSet is required (as the report designer did before). For more information on how to create typed DataSets through Visual Studio please see: HOW TO: Create and Use a Typed DataSet by Using Visual C# .NET

Regards,
Svetoslav
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
Lior ef
Top achievements
Rank 1
answered on 06 Jun 2010, 10:00 AM
hi svetoslav,

having the same problem, i just read in the here: http://www.telerik.com/help/reporting/objectdatasource.html
that i can still use dataset as datasource when working with ObjectDataSource as the datasource,
can you please provide some code samples or explain how to work with typed Dataset that has more than one table in it,
when the report is using fields from more than one table from the typed dataset?

my project reply on typed dataset to manipulate data during run time so using sqldatasource is really out of the question.

thanks so much in advance.
0
Steve
Telerik team
answered on 07 Jun 2010, 05:40 PM
Hello Lior ef,

As explained in the article you've referenced:
"If the DataSource reference contains more than one table, you must set the DataMember property to a string that specifies the table to bind to. For example, if the DataSource is a DataSet or DataViewManager that contains three tables named Customers, Orders, and OrderDetails, you must specify the table to bind to."

In short, if you need fields from more than one table into the same report, you should use either a SubReport or a Table/Crosstab/List report items, which are separate data regions (i.e. have DataSource of their own).

Kind regards,
Steve
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Tags
General Discussions
Asked by
Naphtali
Top achievements
Rank 1
Answers by
Svetoslav
Telerik team
Lior ef
Top achievements
Rank 1
Steve
Telerik team
Share this question
or