OraFAQ Forum: Forms » Passing Parameter List without Showing the Parameter Forms

Home » Developer & Programmer » Forms » Passing Parameter List without Showing the Parameter Forms

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

Passing Parameter List without Showing the Parameter Forms [message #601656]

Sat, 23 November 2013 15:13

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

Hi,

I have made a form that goes to a report...........
I have included a where condition to the report,,,,
My program is working as the following
first I have to fill the field in the form.
I click in a button that prints my report ,,,
as the picture 1 shows,,

http://s16.postimg.org/7y7c9p439/image.jpg

then, you can see how the parameter form is shown,,,, in picture 2

http://s9.postimg.org/aey3oja0v/image.jpg

after that the report will be shown in picture 3

http://s16.postimg.org/mz9mqymt1/image.jpg

********************************************************************************
I used this code to pass the parameters ,,,,

declare
pl_id ParamList;

BEGIN
pl_id := Get_Parameter_List('tmpdata');
IF NOT id_NULL(pl_id)Then
destroy_parameter_LIST(pl_id);
END IF ;
pl_id := create_Parameter_List('tmpdata');

Add_parameter(Pl_id,'P_B_N',TEXT_PARAMETER,:CHEQUE_TABLE.BENEFICIARY_NUMBER);

Add_parameter(Pl_id,'P_M_I',TEXT_PARAMETER,:CHEQUE_TABLE.MATURITY_IN);
run_product(REPORTS,'CHEQUE.REP',SYNCHRONOUS,RUNTIME,FILESYSTEM,pl_id,NULL);
END;

********************************************************************************************

Now, you can see in picture 2 ,, the user can change the data,,,
I don't want the Parameter Form to be shown to the user, I want the report to be displayed directly,,,,,
I mean that picture 2 is not to be displayed

Attachment: 1.jpg
(Size: 46.96KB, Downloaded 923 times)

Report message to a moderator

Re: Passing Parameter List without Showing the Parameter Forms [message #601683 is a reply to message #601656]

Sun, 24 November 2013 08:05

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

Dear its very easy follow these steps

in report builder select the parameter form.
and must select DESTYPE & DESNAME parameters;

-------RUN REPORT--------

and set destination type printer
this automatically will change the Destination Name parameter to printer name

Like example : AGFA-AccuSet v52.3------->printer name
copy this name

Add_Parameter(PL_ID, 'DESTYPE', TEXT_PARAMETER, 'PRINTER');
Add_Parameter(PL_ID, 'DESNAME', TEXT_PARAMETER,'AGFA-AccuSet v52.3');---copy that printer name here.

RUN_PRODUCT(REPORTS,'C:\MUGHAL.RDF',SYNCHRONOUS,RUNTIME,FILE);

Hope you got everything dear its very easy if you still have a confusion then let me know
i will make sample.FMB file for you.

Regard
Mughal

[Updated on: Sun, 24 November 2013 08:07]

Report message to a moderator

Re: Passing Parameter List without Showing the Parameter Forms [message #601686 is a reply to message #601683]

Sun, 24 November 2013 08:31

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

After followed above instructions you code shall be something like this.

   declare
      pl_id ParamList;
   BEGIN
      pl_id := Get_Parameter_List('tmpdata');
         IF NOT id_NULL(pl_id)Then
         destroy_parameter_LIST(pl_id);
   END IF ;
pl_id := create_Parameter_List('tmpdata');

Add_parameter(Pl_id,'P_B_N',TEXT_PARAMETER,:CHEQUE_TABLE.BENEFICIARY_NUMBER);
Add_parameter(Pl_id,'P_M_I',TEXT_PARAMETER,:CHEQUE_TABLE.MATURITY_IN);
Add_Parameter(PL_ID, 'DESTYPE', TEXT_PARAMETER, 'PRINTER');
Add_Parameter(PL_ID, 'DESNAME', TEXT_PARAMETER,'AGFA-AccuSet v52.3');---copy that printer --name here.
run_product(REPORTS,'CHEQUE.REP',SYNCHRONOUS,RUNTIME,FILE);
END;

[Updated on: Sun, 24 November 2013 08:32]

Report message to a moderator

Re: Passing Parameter List without Showing the Parameter Forms [message #601690 is a reply to message #601656]

Sun, 24 November 2013 09:10

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

Add_Parameter(PL_ID, 'DESNAME', TEXT_PARAMETER,'HERE THE NAME************');---copy that printer --name here.

???????????

Report message to a moderator

Re: Passing Parameter List without Showing the Parameter Forms [message #601709 is a reply to message #601690]

Sun, 24 November 2013 13:38

mughals_king
Messages: 392
Registered: January 2012
Location: pakistan

Senior Member

Dear its simple i am talking about printer which you have installed in your pc or server whether it is network printer or local prnter if network printer will be like

'\\AGFA-AccuSet\v52.3_name'---this you have to copy & paste

AGAIN I AM REPEATING MY ANSWER

in report builder select the parameter form.
and must select DESTYPE & DESNAME parameters;

See in the picture after that run the report

-------RUN REPORT--------

and set destination type printer

this automatically will change the Destination Name parameter to printer name

Like example : AGFA-AccuSet v52.3------->printer name which you have installed in your pc or server.

copy this PRINTER name

please see the all pictures which i have uploaded

Regard
Mughal