Hi to all!
I have a problem with my data report.
when I pass these values to the parameters for the first time, it will produce the output correctly. On the second processing, the output will never change. The output is still the same.
An example is when I input values for dates of sales that occured in range with November 11 - November 16, it will produce the correct output. However, in the second processing like I input values like dates December 1 and December 25, the output does not change. It will display the sales from November 11 - November 16.
Here is the code...
Is this has something to do with the parameters passed to the data environment command qrySalesReport?VB Code:
Private Sub cmdProcessReport_Click() deOrders.Commands(6).Parameters(0).Value = s_date deOrders.Commands(6).Parameters(1).Value = e_date End Sub Private Sub cmdViewReport_Click() rptSalesReport.WindowState = vbMaximized rptSalesReport.Show End Sub
Hoping for any response....![]()
![]()
![]()




Reply With Quote