Set connection string for sub-report

[Keith]

Is there a way to set the data source of a report to an Entity Data Source that does NOT point to a specific entity?  I have a report that I am trying to generate but the report requires data from multiple entities, and I would prefer not to have a sub-report of sub-reports, so I was wondering of there was a way to set the data source to multiple entity objects?  If this doesn't make sense or you need any further explanation please let me know.  Any information would be appreciated.

[Keith]

Never mind I found that if you add tables individually using the toolbox, you can use the table wizard which allows you to specify a specific DataSource.  While this is not ideal as there are some instances where I would have two tables visually together being bound to two separate DataSources.  This allows me to move forward past this issue.

[Katia]

Hi Keith,

EntityDataSource component allows you to connect to a single entity data model. If the data comes from multiple entities the approach you can use is the same as described in your last post.

You can use separate data items (Table, Crosstab, List) in the report and connect each of them to a separate data source.

Note that if both a report and its nested data item are bound to the same data source, each will develop its designed template per data record in the data source - Data Binding Problems(Repeating data).


Regards,
Katia
Telerik by Progress