Need help to write code for print button.........! [message #264425] |
Mon, 03 September 2007 05:01  |
james_aron
Messages: 32 Registered: July 2007 Location: chennai
|
Member |
|
|
Hi all,
I am working in oracle forms 6i.I am creating forms for ordering product/quantity(Entering quantity/product details). In my form i have "Print button" to print the quantity details which is in multi-record block(database item).Please help me of how to write code for print button. If u had any source code please post it.
Please help asap......!
Thanks
regards,
jame
|
|
|
Re: Need help to write code for print button.........! [message #264459 is a reply to message #264425] |
Mon, 03 September 2007 07:33   |
bbaz
Messages: 138 Registered: April 2007
|
Senior Member |
|
|
Posting the Source Code is as doing the job for other people, this is not how this FORUM works, we are all here to help each other find solution and not to do the job for other people.
Kindly send a screen shot, FMB file, or provide more description in order to make it easier for others to understand your problem/request.
Thanks,
Baz
|
|
|
|
|
|
Re: Need help to write code for print button.........! [message #264920 is a reply to message #264425] |
Wed, 05 September 2007 00:56   |
|
For Simple Report
Run_Product(REPORTS, 'LE_M5031.REP', SYNCHRONOUS, RUNTIME,
FILESYSTEM, 'Null');
For Parametric Report
Suppose we have a report in which we passes deptno and hire date. Report will show List of employess Appointed in those Dated.
declare
plist Paramlist;
begin
plist := create_parameter_list('SLCL');
add_parameter(plist,'sdate',text_parameter,:sdate);
add_parameter(plist,'edate',text_parameter,:edate);
add_parameter(plist,'Dno',text_parameter,:Dno);
add_parameter(plist,'paramform',text_parameter,'NO');
--add_parameter(plist,'destype',text_parameter,'PRINTER');
Run_Product(REPORTS, 'LE_M5031.REP', SYNCHRONOUS, RUNTIME,
FILESYSTEM, plist);
destroy_parameter_list(plist);
end;
Things to be note
sdate and edate are the paremeters declare in the report .
:Sdate and :edate are the text item use in datablock
'Dno' also a parameter declare in Report and :Dno use in data block.
once on enter the data the respective field i.e Sdate Edate and P
these parameter fetch into reports Parameters and Report Runs
Regards
Danish Hayder
|
|
|
|
|
|
|
|
|