Re: Hide parameter form when calling a report

From: Road Warrior <xpoitras_at_sympatico.ca>
Date: Sun, 12 Mar 2000 01:39:29 GMT
Message-ID: <lzCy4.39860$pf4.1368466_at_news20.bellglobal.com>


use the parameter for parameter form and set it to NO

"Dante Tang" <c8354710_at_comp.polyu.edu.hk> a écrit dans le message news: 01bf8b83$0b5d3e20$3d08849e_at_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 Sun Mar 12 2000 - 02:39:29 CET

Original text of this message