Complicated Report

Hi,

I'm completely new to Crystal Reports and I'm trying to do something, but don't have a clue how to do it.

I've got to run a query on a database as follows:


select * from _procset where _procset.id in (

SELECT DISTINCT _ProcSet.ID
FROM _Proc INNER JOIN
_ProcSet ON _Proc.ProcSetID = _ProcSet.ID INNER JOIN
_ProcInst ON _ProcInst.ProcID = _Proc.ID)
order by name

This is fine, this will display on the report, but for each row that is returned I need to add another field onto the end of it, that gets another value from the database, based on and id number that is returned in the main query. Can anyone tell me how I would do this?

Cheers,

Auld Nick

Maybe look at creating a subreport to hold the additional data
based upon that one fields value passed to it by a parameter?