schaafr
Apr 9th, 2000, 08:31 AM
Hey!
I'm making reports in vb using data reports (unfortunately I can't use crystal reports). I'm trying to set the command text for a command in my data environment using
dataenvironment1.commands("employee_history").commandtext="select * from employee_history where date> 3/1/2000"
This works perfect when I set it directly in the property for the command, but if I set it in code before I open this certain report it gives me the error "Data Employee.firstname not found"
I have the employee table as a child to the employee_history table.
Any ideas?
I'd really appreciate it!
Robin
I'm making reports in vb using data reports (unfortunately I can't use crystal reports). I'm trying to set the command text for a command in my data environment using
dataenvironment1.commands("employee_history").commandtext="select * from employee_history where date> 3/1/2000"
This works perfect when I set it directly in the property for the command, but if I set it in code before I open this certain report it gives me the error "Data Employee.firstname not found"
I have the employee table as a child to the employee_history table.
Any ideas?
I'd really appreciate it!
Robin