| Calling a report from form without showing parameter form [message #82154] |
Tue, 29 April 2003 06:24  |
Zafar
Messages: 2
Registered: November 2000
|
Junior Member |
|
|
I am calling a report from a form. For this, I am using a push button. I am also creating a parameter list and the parameters to report. I want my report directly in preview or print. But the problem is that when it has parameters, report shows the parameter form. But if you don't have any parameter, then it does not show. I am using form/report 6i
Thanks
|
|
|
|
| Re: Calling a report from form without showing parameter form [message #82156 is a reply to message #82154] |
Tue, 29 April 2003 23:43  |
Muzzammil
Messages: 99
Registered: February 2003
|
Member |
|
|
Hi Zafar,
If you are taking about the passing parameters displaying on report parameter form, open your report click tools and click Parameter Form Builder and check may be the passing parameters are in selected for parameter form. Remove highlights from the parameter.
Hope this is you are looking for.
Muzzammil.
|
|
|
|
|
|
| Re: Calling a report from form without showing parameter form [message #83835 is a reply to message #82154] |
Wed, 17 December 2003 18:24 |
Santosh Kshirsagar
Messages: 3
Registered: October 2003
|
Junior Member |
|
|
for all
who want to call report from form and also want
to supply parameter to report.execution of report without showing parameter form.
here is my code as following
where report on path c:sample.rdf having p1 and p2
paramters
form having button on which pf1 and pf2 fields
on button any of the two following is working nicely
Hope it will help you
code --
declare
pid ParamList;
BEGIN
pid := Get_Parameter_List('san');
IF NOT Id_Null(pid) THEN
Destroy_Parameter_List( pid );
END IF;
pid := Create_Parameter_List('san');
Add_Parameter (pid, 'p1',
TEXT_PARAMETER,:fp1);
Add_Parameter(pid, 'p2',
TEXT_PARAMETER, :fp2);
ADD_PARAMETER(pid, 'PARAMFORM',
TEXT_PARAMETER, 'NO');
Run_Product(REPORTS, 'c:sample.rdf', SYNCHRONOUS,
RUNTIME,
FILESYSTEM, pid, NULL);
end;
or
begin
host('C:orawin95BINRWRUN60.EXE
c:sample.rdf user/password@dbase
paramform=no p1='||:fp1||
' p2='||:fp2);
end;
santosh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
