OraFAQ Forum: Reports & Discoverer » Passing parameters from Forms to Reports

Home » Developer & Programmer » Reports & Discoverer » Passing parameters from Forms to Reports

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Passing parameters from Forms to Reports [message #88424]

Tue, 27 August 2002 02:29

Suresh Krishna
Messages: 5
Registered: June 2002

Junior Member

My report is based on a table from which I want to filter a few records based on the passing dates.

I am calling the report from the form itself. This form contains two date inputs (From date & two date) as text fields and these values I want to pass into the report query,(Select * from
where date >=&<= passed )

Report message to a moderator

Re: Passing parameters from Forms to Reports [message #88433 is a reply to message #88424]

Wed, 28 August 2002 19:51

Rengaprabhu
Messages: 18
Registered: August 2002

Junior Member

u can use like this....
assume u'r column name :fdate and :tdate
select * from table where date between :fdate and :tdate
or
select * from table where date > :fdate and date < :tdate

prabhu

Report message to a moderator

Re: Passing parameters from Forms to Reports [message #88437 is a reply to message #88433]

Thu, 29 August 2002 21:51

Amitabha Palit
Messages: 8
Registered: August 2002

Junior Member

SELECT * FROM
WHERE
NVL(TO_CHAR(TABLE_DT,'DD-MON-YY'),' ')
BETWEEN
NVL(:ST_DATE_PARAM,NVL(TO_CHAR(TABLE_DT,'DD-MON-YY'),' '))
AND
NVL(:END_DATE_PARAM,NVL(TO_CHAR(TABLE_DT,'DD-MON-YY'),' ')) ;

FOR ANY FURTHER QUESTION CONTACT,,,

Report message to a moderator