when i said parameters, i mean on the report side, sorry for the confusion.
if you are building a string and executing it from your report, without parameters, you need to follow the full oracle syntax and rules...oracle doesn't allow variables with @ in them.
I don't have oracle handy right now, but here's the basic syntax, I believe.
the param_ replacing @ is not required, iot's just a naming convention and is completely optional, i just used it for clarity.
DECLARE
param_bdate DATE;
param_edate DATE;
SET param_bdate = TO_DATE('01/15/2010','MM/DD/YYYY');
SET param_edate = TO_DATE('01/15/2010','MM/DD/YYYY');
Select * from mytable
Where mytable.date Between param_bdate AND param_edate ;
Lowell