Creating Date Range Parameters
I have created the date range parameter using the parameter fields, but when I refresh the report the data does not get affected. It gives the same result as it would have given without the date parameter. What needs to be done in order for the parameter to actually work.?
Don Williams replied
You can't edit the WHERE clause in CR Designer, it gets generated when you create a record selection formula. And as long as CR can pass the formula fields to the SQL directly it should be there when you Show SQL. If you don't see it then the parameters are not formatted in a way CR can add it directly to the SQL.
To see this add a record selection formula off of one of your number fields. Example: = 1234.
You should see that in the SHOW SQL. So when you add a date parameter if you don't see it then CR can't interpret the value you are passing.