data report output still the same

[KGComputers]

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...

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

Is this has something to do with the parameters passed to the data environment command qrySalesReport?

Hoping for any response....

[rush_shri]

why don't you try "rptsalesreport.refresh" before passing parameters.

[KGComputers]

Hi rush_shri!

I tried it already. Inserting the refresh before the parameters will display the report first, then an error message will appear. The message is Parameter1 has no default value..

[dee-u]

Are you using a client-side cursor?

[KGComputers]

Greetings!!!!

Yes, Im using (use client-side cursor) for my cursor location....

[dee-u]

Have you tried...

rptSalesReport.Refresh

[techgnome]

Crystal, right? Open the report, and under the File menu... make sure the "Save Data With Report" option is TURNED OFF. For what ever reason, this is turned on by default. We ran into this problem we ran into early on with CR until some one figured it out.

-tg

[KGComputers]

Hi!!!

Im still using the built in data report designer....