Printable View
Hi
I am trying to pass a parameter using reports 6i, I have written a query saying
select feild1,feild2
from
where shipdate = '&v_shipdate';
when i run the report it ask to enter the shipdate.It is just working for one date i.e is 27-sep-02,the records are reterieved.when i enter any other date the records are not being retrieved.Please help me in this regard.It will be a great help
Thanks
Murali
Look to see if someone (you?) hard-coded a date as a parameter (or set it as a variable). Where is the report being called from? A form? You can also destroy and re-build a parameter list.
Quote:
Originally posted by stecal
Look to see if someone (you?) hard-coded a date as a parameter (or set it as a variable). Where is the report being called from? A form? You can also destroy and re-build a parameter list.
I am passing parameter from a report.I am using a lexical parameter.please help me
Is it possible your data has only the one date to work with?
Do a select distinct shipdate from table_name where rownum < 5 (the rownum < 5 is to limit the output - just need to see if there is more than one date in your table).