Run a Form from report 1

[prosuc]

The developer demo show a drill down from a report, calling a new report. I want to know if is possible run a Form from report.

I try the following command from a button in the report :
SRW.RUN_PRODUCT(FORMS,'c:\forms\xxxx.fmx')

but, I cant compilate the PL/SQL.

thanks.
Pablo.

 

[smart99]

srw.run_product is not valid built in, so ur getting compilation errors.

 

[prosuc]

then????

don't exist a valid solution?

 

[HimanB]

Hi Pablo,
This can be achived if you generate your report in PDF Format , open the PDF report and then Press the button to call your form as follows:

Step 1:
Create a Push button in your report.

Step 2:
Open the Property pallete of the Button
--> Under button Behaviour property
--> Set Type to PL/SQl
--> In PL/Sql trigger write a null as follows:

procedure U_1ButtonAction is
begin
 null;
end;

--> Under Advanced Layout Property
--> Click on Format Trigger and write following code:

function U_1FormatTrigger return boolean is
 L_rep_string     varchar2(3000);
begin
 L_rep_string := 'ifrun60 D:\Projects\ALS\Forms\ALSD0650.fmx userid=scott/tiger@dbn020';  
 srw.set_pdf_action(L_rep_string );
 return (TRUE);
end;

Generate the report in PDF format.

Open the PDF report.

Click on Push button, your form will be called as required.

HTH
Regards
Himanshu

 

[prosuc]

thanks Himanshu