OraFAQ Forum: Forms » Calling Report Designer 5.0u (MRD) from oracle form builder 6i

Home » Developer & Programmer » Forms » Calling Report Designer 5.0u (MRD) from oracle form builder 6i (form 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Calling Report Designer 5.0u (MRD) from oracle form builder 6i [message #484608]

Thu, 02 December 2010 00:15

NaeemAlsaadi
Messages: 20
Registered: November 2010
Location: Oman

Junior Member

hi

i tried to call Report Designer 5.0u Editor (MRD) it is not supported Oracle tools products from form builder Ver6i i try to use RUN_PRODUCT built-in but is not work please tell me how i can call products not supported by oracle like Crystal Reports XI , Report Designer
i located my file in my local PC C:\temp\VD.mrd

please do the needful

Report message to a moderator

Re: Calling Report Designer 5.0u (MRD) from oracle form builder 6i [message #484634 is a reply to message #484608]

Thu, 02 December 2010 03:34

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Use host to call it from the command line

Report message to a moderator

Re: Calling Report Designer 5.0u (MRD) from oracle form builder 6i [message #484947 is a reply to message #484634]

Fri, 03 December 2010 22:37

NaeemAlsaadi
Messages: 20
Registered: November 2010
Location: Oman

Junior Member

thanks cookiemonster
but how i use host to call it - also i hear that i can use shell command but i don't know how i use it

Report message to a moderator

Re: Calling Report Designer 5.0u (MRD) from oracle form builder 6i [message #484958 is a reply to message #484947]

Sat, 04 December 2010 04:56

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

host allows you to call things from the command line. If you don't know how to call these programs from the command line then this is the wrong place to ask, since they're not oracle products. I'd start by looking in the programs documentation.

Report message to a moderator

Re: Calling Report Designer 5.0u (MRD) from oracle form builder 6i [message #485007 is a reply to message #484958]

Sun, 05 December 2010 00:06

NaeemAlsaadi
Messages: 20
Registered: November 2010
Location: Oman

Junior Member

thanks bro

i solve my problem i use host command to open my file below the script

BEGIN

--Client_Host('cmd /c RunDLL32.EXE shell32.dll,ShellExec_RunDLL C:\temp\VD.mrd'); -- For Oracle Form 10g
host('cmd /c RunDLL32.EXE shell32.dll,ShellExec_RunDLL C:\temp\VD.mrd'); -- For Oracle Form 6i

Exception when form_trigger_failure then null ;
Message('OK');

END;

Report message to a moderator

Re: Calling Report Designer 5.0u (MRD) from oracle form builder 6i [message #485020 is a reply to message #485007]

Sun, 05 December 2010 03:13

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

thanks for letting us know

Report message to a moderator

Re: Calling Report Designer 5.0u (MRD) from oracle form builder 6i [message #485027 is a reply to message #485020]

Sun, 05 December 2010 06:15

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

NaeemAlsaadi

exception 
  when form_trigger_failure then
    null;
    message('OK');

So what does that mean? Read in plain English: when form fails, do nothing and say "OK".

If I were your end-user, I'd be happy thinking that everything went just fine ("OK"). I might find myself puzzled a few moments later.

Report message to a moderator

Re: Calling Report Designer 5.0u (MRD) from oracle form builder 6i [message #485030 is a reply to message #485027]

Sun, 05 December 2010 07:32

NaeemAlsaadi
Messages: 20
Registered: November 2010
Location: Oman

Junior Member

Littlefoot wrote on Sun, 05 December 2010 16:15

NaeemAlsaadi
exception 
  when form_trigger_failure then
    null;
    message('OK');
So what does that mean? Read in plain English: when form fails, do nothing and say "OK".

If I were your end-user, I'd be happy thinking that everything went just fine ("OK"). I might find myself puzzled a few moments later.

this not for end user but for me i want to know the status of my process you can ignore it bro and do not disturb yourself

Report message to a moderator