How to use Multiple Tablix Control in Report Body, to use Two datasets data into one data stet. RRS feed

  • Question

  • Hi Friends,

         I am Ali, I want to create a Report in Report Builder Based on the Two Lists.

    For This,

    1. Created Data Source, and Created Two Data Sets. Because at sharepoint will not accept two lists in report.

    2. To retrive data from two lists , we need use multiple tablix control in the report body in sequence itseems. and This looks like all data comes from one dataset in one tablix itseems.

    3. My doubt is how to use Multiple Tablix control and where is that location.

    Please any body help me



    MD.Liakath ali
    Thursday, November 4, 2010 4:03 AM


  • Hi Ali

    As far as I understand you cannot combine two datasets in a matrix with the exception of SQL 2008R2 which allows you to use a Lookup() function within a dataset to lookup a value in another dataset (equivalent to a join in SQL).

    A matrix can only be bound to one dataset.


    • Proposed as answer by Jerry Nee Friday, November 5, 2010 9:37 AM
    • Marked as answer by Jerry Nee Wednesday, November 10, 2010 5:41 AM
    Thursday, November 4, 2010 5:03 AM