Post reply

Tablix with 2 different dataset content

  • September 20, 2012 at 10:18 am

    #281982

    Hi geniuses!

    It is possible in 1 tablix to have data from different datasets?

    And from different datasources?

    Thanks to all

    Regards

  • September 20, 2012 at 10:48 am

    #1540237

    You can use the lookup/lookupset function in SSRS 2008 to access data from different data sets.

    Also you can get aggregated data from different data sets using aggregation function like this:

    =Sum(Fields!Balance.value, "Dataset")

    As different data sets get data from different data sources, you can get data from different data sources into the same tablix.

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

  • September 20, 2012 at 11:13 am

    #1540264

    Thanks H4K!

    Lets say that I want to add in my tablix, a column : 'Allocation' where the data is in DATASET3. (Field: allocationvalue)

    I'm trying to do as you said but, I must be doing something wrong.

    Can you write me the expression for this example?

    Thanks

    Regards

  • September 20, 2012 at 11:44 am

    #1540276

    It depends on what you need to do.

    There are two different cases as follows and also in my earlier post:

    Case 1) You can use the lookup/lookupset function in SSRS 2008 to access data from different data sets.

    Case 2) Also you can get aggregated data from different data sets using aggregation function like this:

    =Sum(Fields!Balance.value, "Dataset")

    For more info, google 'lookup in SSRS' and check whether that is what you want.

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply