Re: Passing Where Clause from Forms5.0 to Reports3.0 at Runtime,Please help I tried all ways.

Hi,

> I have to call Reports 3.0 from Forms 5.0 and pass Where Clause so that i get
> the report based on that clause.
> ....
> reports. My query in the reports looks like this:
>
> select &p1 staff_c,&p2 staff_c...... from xyz where &p;
>
> Here for all the column parameters it is passing ,but not &p WHERE Clause.

Modify your query as:

select &p1 staff_c,&p2 staff_c...... from xyz &where_clause

and pass the where clause including the "where" keyword.

HTH,
Sameer

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 22 1999 - 18:24:54 CEST