Home » Developer & Programmer » Reports & Discoverer » Reports where_clause
Reports where_clause [message #89700] Tue, 29 June 2004 03:09 Go to next message
tt
Messages: 16
Registered: September 2000
Junior Member
Hi,

I new with Oracle Reports and i'm using version 9i.

Question : If i have two different forms calling the same report, is it possible to change the where_clause of the report query depending on which form i'm printing from ???

Any help will be very much appreciated.
Re: Reports where_clause [message #89702 is a reply to message #89700] Tue, 29 June 2004 07:07 Go to previous messageGo to next message
Steve
Messages: 190
Registered: September 1999
Senior Member
Tt-

Yes it is possible. You need to use what is known as LEXICAL PARAMETERS. You can replace the entire where clause (if that is suitable) with this approach. The syntax would be:

select *
from table_name
&where

&where would consist of all the parameters you would want to pass to the where clause. You would build your form (this is known as building a flexible front-end, extremely useful and eliminates the need for so much repetition!) and pass those values determined in the form to the report via the &where. The exact methodology on how to accomplish this I am still uncertain about, maybe somebody else can walk you through it? Hope I have helped somewhat.

Regards,
Steve
Re: Reports where_clause [message #89712 is a reply to message #89702] Fri, 02 July 2004 03:57 Go to previous messageGo to next message
tt
Messages: 16
Registered: September 2000
Junior Member
Thanx a lot steve.
Re: Reports where_clause [message #89716 is a reply to message #89700] Sat, 03 July 2004 21:11 Go to previous message
Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta
Member

Do this

Make one Parameter inyour report named
V_WHERE varchar2(2000)

Now your query should be like this

select ename, dept_code, sal
from emp
&V_WHERE

Now through your FormPass the respective string for where cluase.

e.g Form_1
V_WHERE := 'WHERE EMP_CODE = XX AND DEPT = 10';

FORM_2
V_WHERE := 'WHERE SAL> 10000';

Enjoy ....
Previous Topic: total per page
Next Topic: Report Orientation
Goto Forum:
  


Current Time: Sat Mar 02 16:50:02 CST 2024