Multiple Datasources for report?

[Chris @ Intrinsic]

Is it possible to use multiple datasources on the one report, and use them at the same time,  like Datasource1.field1,  Datasource1.field2, datasource2.field1, etc.?  I've already searched the forums and google, and the posts are all from 2008, so maybe it has been improved since then?

[Chris @ Intrinsic]

I see you can create subreports.  But, then the question is how do you create a subreport?  How do you embed it?  I see that you are supposed to see a telerik report option in the toolbox, but it doesn't exist.  how do you get it to appear?  I think telerik reporting didn't install correctly? 

[Chris @ Intrinsic]

Fixed it myself again.   I had to right click on the toolbox, then click reset toolbox.  The telerik toolbox items all came back.  So, now I see you can add a subreport.  So, I guess you have to create another report then assign the report to the subreport.  the documentation doesn't tell you to do this specifically.    I see the walkthroughs and examples, but they are from .net 2.0 days.   

[Chris @ Intrinsic]

Another question about report datasources:

I have one dataset with multiple tables.  i want to use those tables for parts of the report.  For example, one table has one record in it, and I want to use it for the top and bottom of the report.  And, one table has multiple records in it, and I want to use it for the detail section.  I can't access any of the fields in the report. (the fields come up blank.)  what should I do in code behind to make sure that the report can view the tables?  I am also using it as a WebService (WCF), so the tables are Not available at design time, but I've got many reports working using my WCF service.

Thanks!

[Chris @ Intrinsic]

FIXED it:

 

report.DataSource = ds1.Tables[

 

"Results"];

 

report.PartDTable.DataSource = ds1.Tables[

 

"Results2"];


so, PartDTable is a table with multiple rows. 

Very straight forward.