Hi,
I currently have two subreports and want to compare the values in each sub report within the main report, but I don't think this is possible.
Subreport 1 - shows number of hours logged by engineers for All Customers.
Subreport 2 - shows number of hours logged by engineers for Managed Service customers only. (Filtered by searching for a ticked check box).
I need to be able to compare the values in Subreport 1 and 2 to be able to say engineer1 spent 65% of his total time working on Managed Service or Engineer2 spend 45% of his total time working on Managed Service.
Any ideas how I can do this? I'm guessing it's possible using SQL scripting rather than subreports, but this is not my strong point. Thanks in advance.