>I need to do a matrix report. I have one parent table and a child table both of which are remote data sources(use SPT).
>
>The parent table describes projects.
>
>The child table lists tasks for each projects and hours to complete each task.
>
>My report needs show a list of projects and total hours scheduled.

Get one cursor, something like:

TEXT TO lcSQL NOSHOW PRETEXT 15
     SELECT Projects.Id,
            Projects.Name,
            SUM(Tasks.Time) AS TotalTime
     FROM  Projects
     INNER JOIN Tasks ON  Projects.Id = Tasks.Fk
ENDTEXT

IF SQLEXEC(...,lcSQL,[ReportCursor]) < 0
   AERROR(laError)
   MessageBox(laError[1,2])
ENDIF

Then use ReportCursor as a report source.