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?


Parents Reply Children
  • 0 in reply to Michael Ericksen

    Parameters can be tricker, especially dates.    Depending on your level of expertise, I like to change Report Manager to SQL mode to debug the SQL.    

    Note: Just make sure you switch it back, its a global setting, so other users will get SQL output once switched.    Annoying, you have to click the radio button AND make sure Excel has the dancing ants outline around the text.   Radio button not enought to switch.

    Typically the SQL ends up being something like this:

    Where the date you specify sub into that parameter  (@STARTDATE@ & @ENDDATE@) make sure you setup your parameter right, make sure "Allow Lookups" is check, Data Type if "Date" and, obviously, its a pass through variable.

    They are case sensitive, so make sure you're watching that.  On the report end, you'll want to make sure you setup the parameter properly

  • 0 in reply to BellScott

    Where do you select the report data output mode?  I cannot find where do to that.  I would like to see the SQL Query.

  • 0 in reply to Michael Ericksen

    I found where to change the output mode and the SQL query looks correct.  The WHERE clause is being ignored.  I added a parameter to select only one order number and I am still getting all the records.

  • 0 in reply to Michael Ericksen

    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.