Hi there, I've created a simple report with a single data source. For simplicity, the query looks something like: select last_name, salaryfrom employees_db_1where employee_id = $P{employee_id)[/code]So the user will need to enter the employee_id and then the name and salary for that employee will be displayed. No issue with that. Now, I'd like the user to enter the employee's nickname as the input instead. However, employee nicknames reside in a separate data source. Basically, the result from the following query needs to be passed as the input parameter to the original report: select employee_idfrom employees_db_2where employee_nickname = $P{employee_nickname}[/code]I've read tutorials that indicate I should create a new report and then include the original report as a subreport. But I'm not clear on how the query output from one data source can be used as the query input in another data source. Thanks in advance for any assistance that you may provide.
