Parameters for a SQL command in a sub report 1

[KTBI]

Hello,

I have a sub report in the detail section of my main report. The sub report uses a sql command to get data. I need to pass a field value from the main report to the sub report to use as a parameter in the sql command in the sub report.
Main report has the field EMPLOYEE.EMPLOYEEID
In the sub report , sql command, I have - Select min(shiftstartdtm),max(shiftenddtm) from sched where empid={?Pm-EMPLOYEE.EMPLOYEEID}
group by calendar date

When I try to do this I get an error "failed to retrieve data from the database. Details: HY000:{Oracle][ODBC][Ora]ORA-24374: define not done before fetch or execute and fetch [Database Vendor Code: 24374]

I am using crystal reports XI and oracle database.

Can anyone please help.
Thanks,
K

 

[lbass]

Try changing the command to:

Select min(shiftstartdtm),max(shiftenddtm), empid
from sched
group by empid, calendar date

Then in the main report, link the subreport to the main report by linking {EMPLOYEE.EMPLOYEEID} to {command.empid}.

-LB

 

[KTBI]

Lbass, Thank you! That worked.