Hi,
I'm having difficulty setting up this report which is based on a sql-pass-through query. I have created the query, called sp_OrderHistory with the following initial values passed through.
sp_OrderHistory 1,1,'01/01/2020','01/01/2020','01/01/2020','01/01/2020'
Now, I'd like to setup criteria for the report for 3 fields: CustomerID (int), ImportDate (datetime) and DeliveryDate (datetime). I've also setup a form for user to enter the criteria. It has text boxes for CustomerID, ImportDate, and DeliveryDate. They are txtCustFrom-txtCustTo, txtImportFrom-txtImportTo, txtDelFrom-txtDelTo.
I am having a difficult time creating the code for the form's "VIEW REPORT" button which would execute the report. Can someone help me with this? Any help is very much appreciated.
Thanks,
TN
I'm having difficulty setting up this report which is based on a sql-pass-through query. I have created the query, called sp_OrderHistory with the following initial values passed through.
sp_OrderHistory 1,1,'01/01/2020','01/01/2020','01/01/2020','01/01/2020'
Now, I'd like to setup criteria for the report for 3 fields: CustomerID (int), ImportDate (datetime) and DeliveryDate (datetime). I've also setup a form for user to enter the criteria. It has text boxes for CustomerID, ImportDate, and DeliveryDate. They are txtCustFrom-txtCustTo, txtImportFrom-txtImportTo, txtDelFrom-txtDelTo.
I am having a difficult time creating the code for the form's "VIEW REPORT" button which would execute the report. Can someone help me with this? Any help is very much appreciated.
Thanks,
TN
