Home Forums Reporting Services Reporting Services Table within a Table with different datasets RE: Table within a Table with different datasets

  • May 4, 2015 at 5:53 am

    #1795323

    One Solution Can be use of Lookupset function:

    use this expression in one cell

    =String.Join(VbCrLF,

    Lookupset(Fields!joinFieldName.Value,

    Fields!joinFieldName.Value,

    Fields!FieldYouWant.Value ,"secondDataset")

    )

    It joins firstDataSet (current) to second dataset and feed result in every new line.

    Excel output is also well!