Reports6i-Parameter
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Reports6i-Parameter

  1. #1
    Join Date
    Jan 2002
    Posts
    111

    Question

    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

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    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.

  3. #3
    Join Date
    Jan 2002
    Posts
    111
    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

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    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).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width