Report table with multiple datasource

2 posts, 0 answers
  1. Simon
    Simon avatar
    77 posts
    Member since:
    Sep 2018

    Posted 18 Jun 2019 Link to this post


    Hello team,

    is it possible to set multiple datasource to a table?

    Probably it is not possible.

    But I need the data from different datasources to display in one report table.

    Is there any trick for this problem?

    I would otherwise create 2 or 3 tables, set one datasource each, and then put them together on the report to make them look like one.

    But it's not so easy.

    It should look good, without distortions.

    So that you recognize what I mean please see the attachment.


  2. Todor
    Todor avatar
    449 posts

    Posted 21 Jun 2019 Link to this post

    Hello Simon,

    Indeed, by design each data item may have only one DataSource.

    I recommend to try to combine the fields from the different data sources that need to be displayed in a single Table into one data source. For example, you may use ObjectDataSource to fetch the data from the original data sources, fill a business object with the necessary data and return it through the DataMember of the ObjectDataSource to the Reporting engine to display it in the Table.

    The approach with multiple Tables simulating a single one may also work. Note that in this case if any of the Table cells grows vertically to accommodate its content, the entire row of this Table will grow. However, the other Tables will preserve their corresponding row height, hence the appearance of a single Table will be lost. Grouping will also be harder to achieve and maintain. In case the data sources return different number of records the entire Table composition will also not look like a single Table.
    These drawbacks will be avoided with the single data source approach.

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