Print report thru form [message #273778] |
Thu, 11 October 2007 12:02  |
mnanias
Messages: 40 Registered: September 2007 Location: AMERICA
|
Member |
|
|
Hi,
I have created a form.When I click on the print button I should be able to print the report of that particular student or some thing like that,so first I started of just displaying the report thru the form,I used the following code in 'when-button-pressed'
*** declare
repid report_object;
v_rep varchar2(100);
begin
repid := find_report_object('YULDPRNRT');
--set_report_object_property(repid,report_filename,'test1');
--set_report_object_property(repid,report_other,'dept_id=10');
v_rep := RUN_REPORT_OBJECT(repid);
end; ****
so it compiled well and when i run the form,got an error msg "SSL failure running another product".I have gone thru all the forums and i didn't find any help or I was not able to understand the solution.The versions i am using are same oracle forms 10g and reports 10g.
I have done all the needful to pop up the report i have done the attachment of my report to report_object in navigator and all other stuff,so can any one help me with this
Thank you in advance.
[Updated on: Wed, 24 September 2008 00:02] by Moderator Report message to a moderator
|
|
|
|
Re: Print report thru form [message #273974 is a reply to message #273867] |
Fri, 12 October 2007 08:13   |
mnanias
Messages: 40 Registered: September 2007 Location: AMERICA
|
Member |
|
|
Hi,
*****
web.show_document('http://Documents and Settings\nm26\Desktop\Nagesh\example.jsp','_blank');
*****
The code above is the one which i used to run my report i was able to open the web browser the display on the screen is "The page cannot be displayed ",its the common error you get when your not connected to the net so please help me in this and one more thing is i wanted to print the report rather than display printing would be more helpful i tried to look up all the forums but i was not able to find the right solution.
Thank You
|
|
|
|
|
|
Re: Print report thru form [message #274256 is a reply to message #273778] |
Mon, 15 October 2007 04:25   |
pushpendra.tomar
Messages: 11 Registered: January 2007 Location: Hyderabad
|
Junior Member |
|
|
Hi,
To run report thru forms use the following command:
RUN_PRODUCT(REPORTS,'REPORT_PATH',SYNCHRONOUS, RUNTIME,FILESYSTEM, pl_id, NULL );
REPORT_PATH : is the complete path of your report.
pl_id : is the parameter list id if you are passing any parameters from forms to reports while execution.
Hope it work for you...
Pushpendra
|
|
|
Re: Print report thru form [message #274298 is a reply to message #274256] |
Mon, 15 October 2007 07:48   |
mnanias
Messages: 40 Registered: September 2007 Location: AMERICA
|
Member |
|
|
HI,
When i am trying to use run_product() it says run_product(report) is no longer supported use run_report_object.
The version i am using is forms 10g.So please help me in this
Thank You
|
|
|
Re: Print report thru form [message #349772 is a reply to message #273778] |
Tue, 23 September 2008 01:33   |
|
PROCEDURE RUN_REPORT IS
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,'TO_JVOUCHER', TEXT_PARAMETER, :JV_REC_MST.JVOUCHER_NO);
-- Add_Parameter(pl_id,'to_date', TEXT_PARAMETER, :tt);
Add_parameter(pl_id, 'Destype', Text_Parameter, 'printer');
Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
Run_Product(REPORTS, 'J:\Accounts\Reports\EXPORT_JVOUCHER.REP', SYNCHRONOUS, RUNTIME, FILESYSTEM, pl_id, NULL);
Destroy_Parameter_List( pl_id );
END;
Thanks
Best, Regards
R I z w a n A d m a n i
I.T ADMINISTRATOR
(OCP Developer
DBA Administrator
CCNA, CCDA, Network Administrator)
Contact : Rizwanadmani@gmail.com
|
|
|
|
Re: Print report thru form [message #349797 is a reply to message #349790] |
Tue, 23 September 2008 02:45   |
|
PROCEDURE RUN_REPORT
IS
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,'TO_JVOUCHER',TEXT_PARAMETER,:JV_REC_MST.JVOUCHER_NO);
-- Add_Parameter(pl_id,'to_date', TEXT_PARAMETER, :tt);
ADD_PARAMETER(PL_ID,'Destype',TEXT_PARAMETER,'printer');
ADD_PARAMETER(PL_ID,'PARAMFORM',TEXT_PARAMETER,'NO');
RUN_PRODUCT(REPORTS,'J:\Accounts\Reports\EXPORT_JVOUCHER.REP',
SYNCHRONOUS,RUNTIME,FILESYSTEM,PL_ID,NULL);
DESTROY_PARAMETER_LIST(PL_ID);
END;
|
|
|
|
|