How can I specify that a report requires parameters? I have a particular report that, when run, needs to prompt the user for a date range and then do something accordingly (a very common scenario in reporting). I have looked at the docs for Active Reports and have tried the syntax described there, but it does not work for me and I get a message that the SQL is invalid. For example, the AR docs say to use a SQL statement similar to the following:
select * from MyTable where SomeDateField >= <%StartDate%> and SomeDateField < <%EndDate%>
How can I have user specified parameters in my reports from OnTime? I'm sure I'm just missing something, but I would have thought it would have been more obvious.