functional data joins and reports