Hello,
I have a report containing two parameters
1. pDept_Code
2. pEmployee_Code
The database contain two tables as follows:
1. Tbl_Dept
--------
Dept_Code
Dept_Name
2. Tbl_Employee
-------------
Employee_Code
Employee_Name
Dept_Code
Let's say I want to print records of all Employees in Dept 01 so I will give the parameter pDept_Code input as 01. But the problem is it also asks for the pEmployee_Code parameter.
Similarly if I want to print record of Employee 001 I will give the parameter pEmployee_Code input as 001 but it also asks for the pDept_Code parameter.
Similary if I do not give any input to any parameter then it should print all the Employees in all the Depts but again it asks for input for pDept_Code and pEmployee_Code both.
How can I avoid that? One solution is to make 2 different reports which I don't want. Any solution?
I have a report containing two parameters
1. pDept_Code
2. pEmployee_Code
The database contain two tables as follows:
1. Tbl_Dept
--------
Dept_Code
Dept_Name
2. Tbl_Employee
-------------
Employee_Code
Employee_Name
Dept_Code
Let's say I want to print records of all Employees in Dept 01 so I will give the parameter pDept_Code input as 01. But the problem is it also asks for the pEmployee_Code parameter.
Similarly if I want to print record of Employee 001 I will give the parameter pEmployee_Code input as 001 but it also asks for the pDept_Code parameter.
Similary if I do not give any input to any parameter then it should print all the Employees in all the Depts but again it asks for input for pDept_Code and pEmployee_Code both.
How can I avoid that? One solution is to make 2 different reports which I don't want. Any solution?