Date Parameters Being Ignored

I am attempting to create an On-Time Shipping Report.  I want to add a parameter to only show items shipped during a certain date range.

I am using the same logic as the OE Sales Report, but my parameters are being ignored and I see all records.

Any ideas?

TIA

Parents Reply
  • I solved my problem.  My database container was wrong.  I had taken information from two different reports.  One was from a JOIN and the other was from a SQL Query.  I had parts of both in my container so it was actually two queries and the first one executed and the parameters were added to the second query.

    Thanks for everyone's help.  The SQL statement was very helpful.  I was able to run that directly from SQL and play with it until I had it  working correctly.

    Thanks again.

Children
No Data