I am not sure how to summarize data from two data sources (SQL Server and Access).  I know how to do it from each data source one at a time (by using grouping and hiding the details), but my internal customer wants it all in one report linked by username.  My trick does not extend to two data sources because there is not a one-to-one relationship between the records.

Here's a simplification:

Data source 1: SQL Server
Username, Time Interval, Quantity, Time
Bob, 7/1/2008 12:30pm, 5, 10
Bob, 7/1/2008 1:00pm, 1, 2

Data source 2: Access
Username, Date, Quantity, Time
Bob, 7/1/2008, 500, 5
Bob, 7/1/2008, 400, 4
Bob, 7/2/2008, 100, 1

Output
Username, AVG Time/Unit 1, AVG Time/Unit 2
Bob, 2, 1


I use Crystal Reports Advanced 10.0 to embed reports in CIC 2.3.1.

It is not feasible to modify the SQL Server.  I would have to go through too much red tape. 

On the SAP forums, I got an interesting answer about subreports, but I am trying to figure out how to pass complex variables

https://forums.sdn.sap.com/thread.jspa?threadID=988084&tstart=0