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

Table with multiple data sources?!

1 Answer 1210 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Frank
Top achievements
Rank 1
Frank asked on 05 May 2016, 03:49 PM

I have a situation where we have six different reports, where they all are basically bringing the data with the similar columns with different values.

The user want to be able to combine all of them into one, yet have each report to show up on a new page. At present the table is tied to a dataset.

My initial thought was to have one table but group it in such a way that for each different group/iteration, i would tie the table to different data source. But I don't think that it is possible from my understanding of other posts in the forum.

What is the best way for me to pull all these 6 different datasets(reports) in one report viewer control? rightnow they can run one report at a time by selecting from dropdown box which will rebind the reportviewer to the report (new data)

except for the binding of different dataset for each report, everything else is same. so it seems pointless to create different report.

Shoul i create six tables each tied to a different dataset?! Please help.

Thanks.

1 Answer, 1 is accepted

Sort by
0
Katia
Telerik team
answered on 10 May 2016, 02:04 PM
Hi Frank,

Data item (Table) can have only one data source and it would not be possible to bind separate table groups to different data sources.

Test if the approach suggested in Changing the connection string dynamically according to runtime data kb article can be applied in your scenario. The article illustrates how a report's data items can be iterated and how their DataSource properties can be updated at run-time.

You can also test using ReportBook item to combine multiple instances of the same report, where each of them will be displayed on a single page.


To provide you more specific suggestions, please attach a report demonstrating your current settings and test data in a support ticket.

Regards,
Katia
Telerik
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 Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Frank
Top achievements
Rank 1
Answers by
Katia
Telerik team
Share this question
or