Hi liw, thanks for reply. Your example uses a Parameter to set the query in the subreport. So, following your example, iReport will ask me the value I want to set for that param before compiling the report and the subreport. Instead I need that the param is automatically set for the query in the subreport taking the value of the primary key of the table used in the main report. The query in the subreport should be something like this: SELECT id, division FROM user_account where company_name = $P{Primary Key From table in main report} Is it possible? Thanks in advance Fabio