Home » Developer & Programmer » Forms » Passing Parameter List without Showing the Parameter Forms
Passing Parameter List without Showing the Parameter Forms [message #601656] |
Sat, 23 November 2013 15:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9996a32bf69a26d576c355127fae6a6d?s=64&d=mm&r=g) |
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 1008 times)
|
|
|
Re: Passing Parameter List without Showing the Parameter Forms [message #601683 is a reply to message #601656] |
Sun, 24 November 2013 08:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/1229663c86eb1a441385fe710cd9116e?s=64&d=mm&r=g) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/1229663c86eb1a441385fe710cd9116e?s=64&d=mm&r=g) |
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
|
|
|
|
|
|
|
Goto Forum:
Current Time: Wed Aug 21 18:51:12 CDT 2024
|