1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Displaying a calender in the parameter form in the report

Discussion in 'Oracle Forms and Reports' started by sureshkomma, Nov 5, 2013.

  1. sureshkomma

    sureshkomma Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Hi All

    I Have a report which consists of parameters. one of the parameter is with DATE datatype.
    I need to display the Calender at the time of passing the value to that DATE parameter at the time of executing.

    Can anyone help on this plz....
     
  2. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Code (SQL):
    SELECT SYSDATE+LEVEL
    FROM DUAL
    CONNECT BY level <= 7;
    As of now this is the alternative. 7 is the number of days.

    Even I am also waiting for the solution....
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Suresh,

    I am also have same requirement,But i didn't get correct solution..
    But alternative solution is use below query. This will give dates from 01-JAN-2000 to 31-DEC-2049.

    Code (SQL):
    (SELECT SYSDATE+LEVEL col1 FROM DUAL CONNECT BY level <= 13204
    UNION SELECT SYSDATE-LEVEL col1 FROM DUAL
    CONNECT BY level <= 5058)