Home Forums Reporting Services Reporting Services 2008 Development Get difference of rows from tables referencing to different databasets RE: Get difference of rows from tables referencing to different databasets

  • May 23, 2013 at 10:26 am

    #1617922

    I would base the tablix on the BIPM dataset and then use an expression similar to this one for the value of each detail textbox in the tablix:

    = Fields!ItemSales.Value - Lookup(Fields!FiscalWeekOfYear.Value, Fields!FiscalWeekOfYear.Value, Fields!ItemSales.Value, "BIPM Audit")

    This expression returns the difference between the ItemSales value in the BIPM dataset and the ItemSales value in the BIPM Audit dataset for corresponding fiscal weeks.