Table with multiple data sources?!

2 posts, 0 answers
  1. Frank
    Frank avatar
    95 posts
    Member since:
    Mar 2012

    Posted 05 May 2016 Link to this post

    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.


  2. Katia
    Katia avatar
    599 posts

    Posted 10 May 2016 Link to this post

    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.

    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
Back to Top