SSRS, merge/use data from 2 .rdl

• mario17

  SSCertifiable

  Points: 6079

  More actions

  September 3, 2013 at 11:49 am

  #395410

  Hi,

  I have SickDays.rdl and Encounters.rdl, they both independent reports in SSRS and implemented as stand alone RDLs. Now I want to produce one more report Average.rdl which as it says will use data from those 2 reports, so Average = SickDays_Number / Encounters_NUmber.

  I' about to merge those 2 codes together to make wanted sql, but wandering if there are any other smart ways to use/share data between reports.

  Appreciate you feedback/thoughts..

  Best

  Mario