Hi All,

I have a report which has one main report and two subreports. Just to explain my problem in detail that my report is as follows:

Main Repot based on a command (select empno, ename, address from emp where deptno = :p_deptno)

Sub Report1 based on a command (select empno, attendace_days from emp_attendance where deptno = :p_deptno)

Sub Report2 based on a command (select empno, sal, comm from emp_sal where deptno = :p_deptno)

You can see that all the reports above are using same parameter name :p_deptno. I have created parameter in commands.
So, when I run the report, it displays three parameter fields. So, I enter department 10 in all the three boxes to run the report. But I want to enter department parameter value just once. What is the best way to achieve this. ?

Thanks,
Zahid

Edited by zahidkhan - 15 Nov 2009 at 4:39am

In this case, why use commands?  Why not join to the tables and set the joins to be on the department number....or set the links to the subreports to be the department passed in from the main report. In a way, it's all the same, I just don't see the need of the command.