How to pass subreport field values as main report parameter in main report sql? Main report Query ------------------------ SELECT PERSONS."ID" AS PERSONS_ID, PERSONS."NAME" AS PERSONS_NAME, PERSONS."CITY" AS PERSONS_CITY FROM "SYSTEM"."PERSONS" PERSONS where PERSONS."ID" = $P{parm} Sub report query ---------------------- SELECT EMAIL_ADDRESSES."ID_PERSON" AS EMAIL_ADDRESSES_ID_PERSON FROM "SYSTEM"."EMAIL_ADDRESSES" EMAIL_ADDRESSES How to pass EMAIL_ADDRESSES_ID_PERSON to $P{parm}? Please help.. Thanks, Bharath M.