Home » Developer & Programmer » Forms » Calling a report from form without showing parameter form
Calling a report from form without showing parameter form [message #82154] Tue, 29 April 2003 06:24 Go to next message
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 Go to previous messageGo to next message
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 #82159 is a reply to message #82154] Wed, 30 April 2003 01:05 Go to previous messageGo to next message
nelson
Messages: 30
Registered: February 2000
Member
Hi Zafar,
The following code will solve ur problem.

Add_Parameter(param_id,'PARAMFORM',TEXT_PARAMETER,'NO');
Where param_id-> Parameter Name
Add this line in ur parameter list coding.
If u face any problem. let me know
Thanks
Candy
Re: Calling a report from form without showing parameter form [message #83835 is a reply to message #82154] Wed, 17 December 2003 18:24 Go to previous message
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
Previous Topic: forms 5 -F50DBG32.exe - Application Error
Next Topic: interview questions for oracle D2K
Goto Forum:
  


Current Time: Fri May 24 02:46:43 CDT 2024