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

[Quoted] [Quoted] 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.

[Quoted] I have got a form with List items in it. I have to select the column in one list item and the value/range for that selected column in another list item.Depending on this WHERE Clause that is selected and the columns that are selected from different list items,i have to get the report in tabular form. My problem is that i cannot pass the Where Clause as parameter to reports.I created a parameter list & added the Parameter to it.before that i extracted the Where Clause in String & passed the string as lexical parameter to the 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.

[Quoted] My second problem is :: in the SELECT statement the column names that i give after the lexical parameter remain as it is.What i want is at runtime whichever column i select its name should be displayed in the Reports.

 It is very urgent .
Please Help!!!!!
 Ur act will be highly appreciated.
THANX in advance..
PALU... -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 21 1999 - 10:45:03 CEST