Parameter passing and using selection formulas in subreports 1

[ppark001]

I am using a subreport for Crystal 8.5. It is an almost exact clone of the container report except for the way the data is presented, but the selection formulas are the same. I am getting the problem of duplicate parameter requests when I refresh the report. I have selected the four parameters when selecting my subreport links, i.e.
{?Date From}
{?Date To}
{?Location }
{?Employee }

I noticed when I use range formula like "IN' for a date range, Crystal sends me a request for the subreport date range twice. Therefore,I created Date From and Date To, linked those and it works. However, the selection formulas below forced me to enter the parameter data twice. Is there a problem you know of in using formulas in subreports?

Thanks,

{TC1_TimecardMastefile.DateWorked}>= {?Date From}
and {TC1_TimecardMastefile.DateWorked}<={?Date To}
////this selection works;no double parameter requests.
AND
(if {?Location } = &quot;ALL&quot; then True
else {TC1_TimecardMastefile.DepartmentNumber} = {?Location })

AND

(If {?Employee } = &quot;ALL&quot; then True
else {TC1_TimecardMastefile.EmployeeNumber} ={?Employee })


Thanks in advance,

P.Park

 

[Naith]

If the subreport is an exact copy of the parent report, you probably have retained the parent parameters entities in the subreport.

Go to the parameter explorer window in the subreport, and delete the parameters from there.

<N>

 

[ppark001]

Thanks,

I did not realize new parameters were created. I found them and deleted.

Thanks again,

P.Park