Here is my query, I have created the parameters, but when I run it I get a message box that says they are not defined. Here is the query as it stands:
SELECT Orderlog.Proc, Orderlog.Order, Orderlog.OpenDate
FROM Orderlog
WHERE Orderlog.OpenDate Between {?Pm-@FirstD} and {?Pm-@SecondD}
ORDER BY Orderlog.Order;
Please let me know where I am going wrong on this. I am new to Crystal and have always used Access for reports. While the query looks similar I am unsure how to make Crystal prompt for input. Thanks for any help!
SELECT Orderlog.Proc, Orderlog.Order, Orderlog.OpenDate
FROM Orderlog
WHERE Orderlog.OpenDate Between {?Pm-@FirstD} and {?Pm-@SecondD}
ORDER BY Orderlog.Order;
Please let me know where I am going wrong on this. I am new to Crystal and have always used Access for reports. While the query looks similar I am unsure how to make Crystal prompt for input. Thanks for any help!