Home » Developer & Programmer » Reports & Discoverer » Run report error
Run report error [message #533310] Tue, 29 November 2011 07:09 Go to next message
aallan
Messages: 150
Registered: October 2011
Senior Member
Dear All;
I faced a problem when i tried to print a report.
i turned on the report server
but i got this error.
  • Attachment: 1.PNG
    (Size: 3.32KB, Downloaded 887 times)
Re: Run report error [message #533311 is a reply to message #533310] Tue, 29 November 2011 07:20 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

which Report Version are you using ?
Re: Run report error [message #533313 is a reply to message #533311] Tue, 29 November 2011 07:23 Go to previous messageGo to next message
aallan
Messages: 150
Registered: October 2011
Senior Member
thx for replay,
its Report Builder 10.1.2.0.2
Re: Run report error [message #533315 is a reply to message #533313] Tue, 29 November 2011 07:28 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Did you restart the Report Server.?
Re: Run report error [message #533317 is a reply to message #533315] Tue, 29 November 2011 07:29 Go to previous messageGo to next message
aallan
Messages: 150
Registered: October 2011
Senior Member
yes i did
and i run it from my pc.
Re: Run report error [message #533318 is a reply to message #533317] Tue, 29 November 2011 07:30 Go to previous messageGo to next message
aallan
Messages: 150
Registered: October 2011
Senior Member
and this is my code:

Declare
    Repid             Report_Object;
    V_Rep             Varchar2(100);
    Rep_Status     Varchar2(20);
    Rep_Name    Varchar2(100);
    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_1', Text_Parameter, To_Char(:Orasys_Emp_Profile.Employeeid));
--    Add_Parameter(Pl_Id, 'Office', Text_Parameter, To_Char(:Blk1.Gpo_Office));
--    Add_Parameter(Pl_Id, 'Cert_Type', Text_Parameter, To_Char(:Blk1.Gpo_Cert_Type));
--    Add_Parameter(Pl_Id, 'Pol_No', Text_Parameter, To_Char(:Blk1.Gpo_Pol_No));
    --Add_Parameter(Pl_Id, 'Ins_Type', Text_Parameter, To_Char(:Blk1.Gpo_Ins_Type));
    --Add_Parameter(Pl_Id, 'Serial', Text_Parameter, To_Char(:Blk1.Gpo_Serial));
--    Add_Parameter(Pl_Id, 'Paramform', Text_Parameter, 'Yes');


Repid := Find_Report_Object('TEST');
Set_Report_Object_Property(Repid,Report_Execution_Mode,Runtime);
Set_Report_Object_Property
(Repid,Report_Comm_Mode,Synchronous);
Set_Report_Object_Property(Repid,Report_Destype,Cache);
Set_Report_Object_Property(Repid,Report_Desformat,'PDF');
Set_Report_Object_Property(Repid,Report_Server,'rep_server');
V_Rep := Run_Report_Object(Repid,Pl_Id);
Rep_Status := Report_Object_Status(V_Rep);

While Rep_Status In ('RUNNING','OPENING_REPORT','ENQUEUED')
Loop
Rep_Status := Report_Object_Status(V_Rep);
End Loop;


If Rep_Status = 'FINISHED' Then
Web.Show_Document
('http://ADMIN:8889/reports/rwservlet/getjobid'||Substr(V_Rep,Instr(V_Rep,'_',-1)+1)||'?'||'server=rep_server&paramform=NO','_blank');
Else
Message('Error when running report');
End If;
 
        Destroy_Parameter_List(Pl_Id);
        
End;
Re: Run report error [message #533321 is a reply to message #533318] Tue, 29 November 2011 07:51 Go to previous message
aallan
Messages: 150
Registered: October 2011
Senior Member
Thx all, i solved it.
i forgot to write:

D:\DevSuiteHome_1\jlib\zrclient.jar;D:\DevSuiteHome_1\reports\jlib\rwrun.jar

in class path.
Previous Topic: ti type arabic in reports 6i
Next Topic: Oracle reports through Excel
Goto Forum:
  


Current Time: Fri Mar 29 10:25:17 CDT 2024