We need to build couple of reports in SSRS that need data from multiple entities of a Mendix application. We have created a Published oData Service containing all the required entities for our SSRS reports. Beyond having associated entity's ID, we don't see attributes of the associated entities. We are looking for design choices/ patterns on how to 'join' the related entities for the above SSRS reports.