Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking parameters

Status
Not open for further replies.

dasiga222

IS-IT--Management
Sep 22, 2003
68
US
Hi

I am using Crystal reports 10

In my report I have two parameter fields
Parameter 1 and Parameter 2
Hi

I am using Crystal reports 10

In my report I have two parameter fields
Parameter 1 and Parameter 2
Actally they are {?emp_deptno }
and {?dept_deptno}

Earlier the users used to enter both the fields .

But now only the emp_deptno needs to be entered and the
dept_deptno will not be entered

Actually the dept_deptno should pick up the same value
as the emp_deptno which was entered earlier
The user will not enter twice. The dept_deptno is used in the code at a lot of places and I do not want to disturb the code

How can I fetch the value of emp_deptno into dept_deptno
parameter field.

Thanks
 
It doesnt look like you need to fetch the value of the first parameter into the second parameter. If they are both the same value, then when in your selection formula, just compare the value of the only parameter you need(emp_deptno), instead of comparing both. For example if your selection formula was:
Code:
{?dept_deptno} = yourdatasource.dept_no 
AND 
{?emp_deptno} = yourdatasource.emp_dept_no

just change it to:
Code:
{?dept_deptno} = yourdatasource.dept_no 
AND 
{?dept_deptno} = yourdatasource.emp_dept_no

then delete the unused parameter from the report.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top