Report not using bind variables

[steeve123]

Hi, i have a application running on forms/reports.
The reports does not use bind variables.
There is always at least 3 critérias sent from forms via user parameter. Example
P_where_order

so if the user print order from 1 to 10. The parameter will be equal to the following. "And no_order between 1 and 10".

The query in the report is like this:
select field1, field2, field3
from order
where blabla = blabla
&p_where_order

So the query will be replace at runtime by
select field1, field2, field3
from order
where blabla = blabla
And no_order between 1 and 10

But that means that each time that report will be execute, the query will always be unique because of hardcoded values 1 and 10.

How can i solve this?

I just want to specify that the criterias are always different, the user is not obligated to put order number critéria, he can choose to run the report by client number, by order date, or even print everything.

[slimdave]

Have you looked at using dynamic SQL with bind variables?

[steeve123]

show me an example with report of course