I checked and I am using the AND logic.  I am filtering on a date field that can be tricky, but I added an individual order number and a specific customer.  I am still getting every record.

Any other ideas?

TIA

Is this a Crystal Report? 

No it is a Sage Intelligence Report.  I am not sure why any parameter I add is being ignore.

TIA

Send an export of the intelligence file.

Where should I send the export.  My e-mail address is [email protected]

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

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

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

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.

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.