Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Creating Date Range Parameters

Hi,

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

Thanks

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

Thank you

Don

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question