Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Hide the parameter form when calling a report

Hide the parameter form when calling a report

From: Dante Tang <c8354710_at_comp.polyu.edu.hk>
Date: 11 Mar 2000 17:58:46 GMT
Message-ID: <01bf8b82$ee426040$3d08849e@default>


Suppose I have a query in a report to retrieve data:

SELECT part_number
FROM part
WHERE part_number = :part_num;

I found that it is impossible to hide the parameter form if I use bind variable in report. So I try to use lexical variable:

SELECT part_number
FROM part
&part_num;

According to my reference book, I can call the report in my form by running the run_product built-in. I have passed the string 'WHERE part_number = :part_num' as the value of the lexical variable &part_num to the report. I have already unchecked the parameter form in the preferences of Report Builder. However, the parameter form still appear....

How can I hide the parameter form if I want to pass a parameter to the report? Do you know the solution? Can you give me a hand?

Thank you very much for your help and kind attention. --
e-mail : c8354710_at_comp.polyu.edu.hk
URL : http://www.comp.polyu.edu.hk/~c8354710 Received on Sat Mar 11 2000 - 11:58:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US