I have a foxfire report, that accepts one input value before it runs. When I edit the sql for the report, it prompts for the value and adds the value to the where clause of the sql statetment. If i now save this sql, this value is hard coded in the sql. Now the report runs with that same value everytime.

How can you edit that sql and still have the report prompt you for a value?

Regards,

Stuart