DECLARE
	v_rep_id		REPORT_OBJECT;
	v_repjob		VARCHAR2(100);
	v_job_id		VARCHAR2(100);
	v_rep_status		VARCHAR2(100);	
	v_reportsrvr		VARCHAR2(50) := 'rep_server';
	v_runformat		vARCHAR2(50) := 'pdf';

 BEGIN	
	v_rep_id := FIND_REPORT_OBJECT('TEST_sys');
	SET_REPORT_OBJECT_PROPERTY(v_rep_id, REPORT_COMM_MODE, SYNCHRONOUS);
	SET_REPORT_OBJECT_PROPERTY(v_rep_id, REPORT_DESTYPE, CACHE);
	
	SET_REPORT_OBJECT_PROPERTY(v_rep_id, REPORT_SERVER, v_reportsrvr);
	SET_REPORT_OBJECT_PROPERTY(v_rep_id, REPORT_DESFORMAT, v_runformat);	
	
	SET_REPORT_OBJECT_PROPERTY(v_rep_id, REPORT_OTHER, 'paramform=no');	
	
	SET_REPORT_OBJECT_PROPERTY(v_rep_id, REPORT_FILENAME, 'TEST_sys.rdf');
	
	v_repjob := RUN_REPORT_OBJECT(v_rep_id);
	v_job_id := SUBSTR(v_repjob, LENGTH(v_reportsrvr) + 2, LENGTH(v_repjob) );
	v_rep_status := REPORT_OBJECT_STATUS(v_repjob);
	
	IF v_rep_status = 'FINISHED' THEN
		--WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid' || v_job_id ||'?server=' || v_reportsrvr || '', '_blank');
Web.Show_Document ('http://aljawal.sale-co.com:8889/reports/rwservlet/getjobid'||Substr(v_job_id,Instr(v_job_id,'_',-1)+1)||'?'||'server=rep_server&paramform=NO','_blank');
	ELSE
			message('Report failed with error message ');

	END IF;
END;

# $Id: formsweb.cfg 15-apr-2005.13:17:30 pkuhn Exp $
# formsweb.cfg defines parameter values used by the FormsServlet (frmservlet)
# This section defines the Default settings.  Any of them may be overridden in the
# following Named Configuration sections.  If they are not overridden, then the
# values here will be used.
# The default settings comprise two types of parameters: System parameters,
# which cannot be overridden in the URL, and User Parameters, which can.
# Parameters which are not marked as System parameters are User parameters.
# SYSTEM PARAMETERS
# -----------------
# These have fixed names and give information required by the Forms
# Servlet in order to function.  They cannot be specified in the URL query
# string.  But they can be overridden in a named configuration (see below).
# Some parameters specify file names: if the full path is not given,
# they are assumed to be in the same directory as this file.  If a path
# is given, then it should be a physical path, not a URL.
# USER PARAMETERS
# ---------------
# These match variables (e.g. %form%) in the baseHTML file. Their values
# may be overridden by specifying them in the URL query string
# (e.g. "http://myhost.mydomain.com/forms/frmservlet?form=myform&width=700")
# or by overriding them in a specific, named configuration (see below)
[default]
# System parameter: default base HTML file
baseHTML=base.htm
# System parameter: base HTML file for use with JInitiator client
baseHTMLjinitiator=basejini.htm
# System parameter: base HTML file for use with Sun's Java Plug-In
baseHTMLjpi=basejpi.htm
# System parameter: delimiter for parameters in the base HTML files
HTMLdelimiter=%
# System parameter: working directory for Forms runtime processes
# WorkingDirectory defaults to <oracle_home>/forms if unset.
workingDirectory=
# System parameter: file setting environment variables for the Forms runtime processes
envFile=default.env

# Forms runtime argument: whether to escape certain special characters
# in values extracted from the URL for other runtime arguments
escapeparams=true
# Forms runtime argument: which form module to run
form=test.fmx
# Forms runtime argument: database connection details
userid=
# Forms runtime argument: whether to run in debug mode
debug=no
# Forms runtime argument: host for debugging
host=
# Forms runtime argument: port for debugging
port=
# Other Forms runtime arguments: grouped together as one parameter.
# These settings support running and debugging a form from the Builder:
otherparams=buffer_records=%buffer% debug_messages=%debug_messages% array=%array% obr=%obr% query_only=%query_only% quiet=%quiet% render=%render% record=%record% tracegroup=%tracegroup% log=%log% term=%term%
# Sub argument for otherparams
buffer=no 
# Sub argument for otherparams
debug_messages=no
# Sub argument for otherparams
array=no
# Sub argument for otherparams
obr=no
# Sub argument for otherparams
query_only=no
# Sub argument for otherparams
quiet=yes
# Sub argument for otherparams
render=no
# Sub argument for otherparams
record=
# Sub argument for otherparams
tracegroup=
# Sub argument for otherparams
log=
# Sub argument for otherparams
term=

# HTML page title
pageTitle=Oracle Application Server Forms Services
# HTML attributes for the BODY tag
HTMLbodyAttrs=
# HTML to add before the form
HTMLbeforeForm=
# HTML to add after the form
HTMLafterForm=

# Forms applet parameter: URL path to Forms ListenerServlet
serverURL=/forms/lservlet
# Forms applet parameter
codebase=/forms/java
# Forms applet parameter
imageBase=DocumentBase
# Forms applet parameter
width=750
# Forms applet parameter
height=600
# Forms applet parameter
separateFrame=false
# Forms applet parameter
splashScreen=
# Forms applet parameter
background=
# Forms applet parameter
lookAndFeel=Oracle
# Forms applet parameter
colorScheme=teal
# Forms applet parameter
logo=
# Forms applet parameter
restrictedURLparams=HTMLbodyAttrs,HTMLbeforeForm,pageTitle,HTMLafterForm,log,allow_debug,allowNewConnections
# Forms applet parameter
formsMessageListener=
# Forms applet parameter
recordFileName=
# Forms applet parameter
serverApp=default
# Forms applet archive setting for JInitiator
archive_jini=frmall_jinit.jar
# Forms applet archive setting for other clients (Sun Java Plugin, Appletviewer, etc)
archive=frmall.jar
# Number of times client should retry if a network failure occurs.  You should
# only change this after reading the documentation.
networkRetries=0

# Page displayed to Netscape users to allow them to download Oracle JInitiator.
# Oracle JInitiator is used with Windows clients.
# If you create your own page, you should set this parameter to point to it.
jinit_download_page=/forms/jinitiator/us/jinit_download.htm
# Parameter related to the version of JInitiator
jinit_classid=clsid:CAFECAFE-0013-0001-0022-ABCDEFABCDEF
# Parameter related to the version of JInitiator
jinit_exename=jinit.exe#Version=1,3,1,22
# Parameter related to the version of JInitiator
jinit_mimetype=application/x-jinit-applet;version=1.3.1.22

# Page displayed to users to allow them to download Sun's Java Plugin.
# Sun's Java Plugin is typically used for non-Windows clients.
# (NOTE: you should check this page and possibly change the settings)
jpi_download_page=http://java.sun.com/products/archive/j2se/1.4.2_06/index.html
# Parameter related to the version of the Java Plugin
jpi_classid=clsid:CAFEEFAC-0014-0002-0006-ABCDEFFEDCBA
# Parameter related to the version of the Java Plugin
jpi_codebase=http://java.sun.com/products/plugin/autodl/jinstall-1_4_2-windows-i586.cab#Version=1,4,2,06
# Parameter related to the version of the Java Plugin
jpi_mimetype=application/x-java-applet;jpi-version=1.4.2_06
# EM config parameter
# Set this to "1" to enable Enterprise Manager to track Forms processes
em_mode=0

# Single Sign-On OID configuration parameter
oid_formsid=%OID_FORMSID%
# Single Sign-On OID configuration parameter
oracle_home=D:\DevSuiteHome_1
# Single Sign-On OID configuration parameter
formsid_group_dn=%GROUP_DN%
# Single Sign-On OID configuration parameter: indicates whether we allow
# dynamic resource creation if the resource is not yet created in the OID.
ssoDynamicResourceCreate=true
# Single Sign-On parameter: URL to redirect to if ssoDynamicResourceCreate=false
ssoErrorUrl=
# Single Sign-On parameter: Cancel URL for the dynamic resource creation DAS page.
ssoCancelUrl=
# Single Sign-On parameter: indicates whether the url is protected in which
# case mod_osso will be given control for authentication or continue in
# the FormsServlet if not. It is false by default. Set it to true in an
# application-specific section to enable Single Sign-On for that application.
ssoMode=false
# The parameter allow_debug determines whether debugging is permitted.
# Administrators should set allow_debug to "true" if servlet
# debugging is required, or to provide access to the Forms Trace Xlate utility. 
# Otherwise these activities will not be allowed (for security reasons).
allow_debug=false
# Parameter which determines whether new Forms sessions are allowed. 
# This is also read by the Forms EM Overview page to show the 
# current Forms status.
allowNewConnections=true

# EndUserMonitoring 

# EndUserMonitoringEnabled parameter
# Indicates whether EUM/Chronos integration is enabled
EndUserMonitoringEnabled=

# EndUserMonitoringURL 
# indicates where to record EUM/Chronos data
EndUserMonitoringURL=

# Example Named Configuration Section
# Example 1: configuration to run forms in a separate browser window with
# "generic" look and feel (include "config=sepwin" in the URL)
# You may define your own specific, named configurations (sets of parameters)
# by adding special sections as illustrated in the following examples.
# Note that you need only specify the parameters you want to change.  The
# default values (defined above) will be used for all other parameters.
# Use of a specific configuration can be requested by including the text
# "config=<your_config_name>" in the query string of the URL used to run
# a form.  For example, to use the sepwin configuration, your could issue
# a URL like "http://myhost.mydomain.com/forms/frmservlet?config=sepwin".
[sepwin]
separateFrame=True
lookandfeel=Generic

# Example Named Configuration Section
# Example 2: configuration forcing use of the Java Plugin in all cases (even if 
# the client browser is on Windows)
[jpi]
baseHTMLJInitiator=basejpi.htm

# Example Named Configuration Section
# Example 3: configuration running the Forms ListenerServlet in debug mode
# (debug messages will be written to the servlet engine's log file). 
[debug]
serverURL=/forms/lservlet/debug

# Sample configuration for deploying WebUtil. Note that WebUtil is shipped with
# DS but not AS and is also available for download from OTN.
[webutil]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
archive_jini=frmall_jinit.jar
archive=frmall.jar
lookAndFeel=oracle

[Saledev]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
form=Sale_Log.fmx
userid=sale/sale@saledev
width=100%
height=100%
separateFrame=True
splashScreen=no
background= 
lookAndFeel=Oracle
colorScheme=blue
logo=no
codebase=/forms/java
imageBase=CodeBase
archive_jini=frmall_jinit.jar,icons.jar, mail.jar, activation.jar and SendMail.jar 
archive=frmall.jar, icons.jar, laf_902.jar, laf_1012.jar, laf_10123.jar, laf_11112.jar, dynamicmenu.jar, Calculator.jar
baseHTMLJInitiator=basejpi.htm
jpi_mimetype=application/x-java-applet;version=1.6
jpi_classid=clsid:CAFEEFAC-0016-0000-0021-ABCDEFFEDCBA
envFile=saledev.env

[Salelive]
WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384
baseHTMLjinitiator=webutiljini.htm
baseHTMLjpi=webutiljpi.htm
form=Sale_Log.fmx
userid=sale/sale@salelive
width=100%
height=100%
separateFrame=True
splashScreen=no
background= 
lookAndFeel=Oracle
colorScheme=blue
logo=no
codebase=/forms/java
imageBase=CodeBase
archive_jini=frmall_jinit.jar,icons.jar, mail.jar, activation.jar and SendMail.jar 
archive=frmall.jar, icons.jar, laf_902.jar, laf_1012.jar, laf_10123.jar, laf_11112.jar, dynamicmenu.jar, Calculator.jar
baseHTMLJInitiator=basejpi.htm
jpi_mimetype=application/x-java-applet;version=1.6
jpi_classid=clsid:CAFEEFAC-0016-0000-0021-ABCDEFFEDCBA
envFile=default.env

# $Id: default.env 14-apr-2005.13:22:43 pkuhn Exp $
# default.env - default Forms environment file, Windows version
#
# This file is used to set the Forms runtime environment parameters.  
# If a parameter is not defined here, the value in the Windows registry 
# will be used. If no value is found in the registry, the value used will
# be that defined in the environment in which the servlet engine (OC4J 
# or JServ) was started.
#
# NOTES
# 1/ The Forms installation process should replace all occurrences of
#    <percent>FORMS_ORACLE_HOME<percent> with the correct ORACLE_HOME 
#    setting, and all occurrences of <percent>O_JDK_HOME<percent> with
#    the location of the JDK (usually $ORACLE_HOME/jdk).  
#    Please make these changes manually if not.
# 2/ Some of the variables below may need to be changed to suite your needs.
#    Please refer to the Forms documentation for details.
#
ORACLE_HOME=D:\DevSuiteHome_1

  #
  # Search path for Forms applications (.fmx files, PL/SQL libraries)
  # If you need to include more than one directory, they should be semi-colon
  # separated (e.g. c:\test\dir1;c:\test\dir2)
  #
  FORMS_PATH=D:\DevSuiteHome_1\forms;D:\DevSuiteHome_1\forms\webutil;D:\Sys_Dev\Forms;D:\Sys_Dev\General

  # webutil config file path
  WEBUTIL_CONFIG=D:\DevSuiteHome_1\forms\server\webutil.cfg

  # Disable/remove this variable if end-users need access to the query-where
  # functionality which potentially allows them to enter arbitrary SQL 
  # statements when in enter-query mode.
  FORMS_RESTRICT_ENTER_QUERY=TRUE

  #
  # The PATH setting is required in order to pick up the JVM (jvm.dll). 
  # The Forms runtime executable and dll's are assumed to be in 
  # D:\DevSuiteHome_1\bin if they are not in the PATH.
  # In addition, if you are running Graphics applications, you will need
  # to append the following to the path (where <Graphics Oracle Home> should
  # be replaced with the actual location of your Graphics 6i oracle_home):
  #
  # ;<Graphics Oracle Home>\bin;<Graphics Oracle Home>\jdk\bin
  # 

  PATH=D:\DevSuiteHome_1\jdk\bin;D:\DevSuiteHome_1\jdk\jre\bin\classic;D:\DevSuiteHome_1\jdk\jre\bin;D:\DevSuiteHome_1\jlib;D:\DevSuiteHome_1\jre\1.4.2\bin\client;D:\DevSuiteHome_1\jre\1.4.2\bin;D:\DevSuiteHome_1\jdk\jre\bin\client
  #
  # Settings for Graphics
  # -------------------------------
  # NOTE: These settings are only needed if Graphics applications 
  # are called from Forms applications. In addition, you will need to
  # modify the PATH variable above as described above.
  #

    #
    # Please uncomment the following and put the correct 6i 
    # oracle_home value to use Graphics applications.
    #
    #ORACLE_GRAPHICS6I_HOME=<your Graphics 6i oracle_home here>

    #
    # Search path for Graphics applications
    #
    #GRAPHICS60_PATH=

  #
  # Settings for Forms tracing and logging
  # -----------------------------------------------
  # Note: This entry has to be uncommented to enable tracing and
  # logging.

    #FORMS_TRACE_PATH=<FORMS_ORACLE_HOME>\forms\server
  

  #
  # System settings
  # ---------------
  # You should not normally need to modify these settings
  #
  FORMS=D:\DevSuiteHome_1\forms

  #
  # Java class path 
  #   This is required for the Forms debugger
  #   You can append your own Java code here)
  # frmsrv.jar, repository.jar and ldapjclnt10.jar are required for
  # the password expiry feature to work(#2213140).
  #
  CLASSPATH=D:\DevSuiteHome_1\j2ee\OC4J_BI_Forms\applications\formsapp\formsweb\WEB-INF\lib\frmsrv.jar;D:\DevSuiteHome_1\jlib\repository.jar;D:\DevSuiteHome_1\jlib\ldapjclnt10.jar;D:\DevSuiteHome_1\jlib\debugger.jar;D:\DevSuiteHome_1\jlib\ewt3.jar;D:\DevSuiteHome_1\jlib\share.jar;D:\DevSuiteHome_1\jlib\utj.jar;D:\DevSuiteHome_1\jlib\zrclient.jar;D:\DevSuiteHome_1\reports\jlib\rwrun.jar;D:\DevSuiteHome_1\forms\java\frmwebutil.jar;D:\DevSuiteHome_1\forms\java\icons.jar;D:\DevSuiteHome_1\jlib\zrclient.jar;D:\DevSuiteHome_1\reports\jlib\rwrun.jar;D:\DevSuiteHome_1\forms\java\jacob.jar;D:\DevSuiteHome_1\forms\java\frmall.jar;D:\DevSuiteHome_1\jdk\jre\lib\rt.jar;D:\DevSuiteHome_1\jlib\zrclient.jar;D:\DevSuiteHome_1\reports\jlib\rwrun.jar
#local=sale
FORMS_PATH=C:\WINDOWS\Fonts;D:\Sys_Dev\GENERAL;D:\Sys_Dev\forms;D:\Sys_Dev\GENERAL\icons
REPORTS_PATH=C:\WINDOWS\Fonts;D:\Sys_Dev\GENERAL;D:\Sys_Dev\Reports

FORMS_MMAP=TRUE

# $Id: default.env 14-apr-2005.13:22:43 pkuhn Exp $
# default.env - default Forms environment file, Windows version
#
# This file is used to set the Forms runtime environment parameters.  
# If a parameter is not defined here, the value in the Windows registry 
# will be used. If no value is found in the registry, the value used will
# be that defined in the environment in which the servlet engine (OC4J 
# or JServ) was started.
#
# NOTES
# 1/ The Forms installation process should replace all occurrences of
#    <percent>FORMS_ORACLE_HOME<percent> with the correct ORACLE_HOME 
#    setting, and all occurrences of <percent>O_JDK_HOME<percent> with
#    the location of the JDK (usually $ORACLE_HOME/jdk).  
#    Please make these changes manually if not.
# 2/ Some of the variables below may need to be changed to suite your needs.
#    Please refer to the Forms documentation for details.
#
ORACLE_HOME=D:\DevSuiteHome_1

  #
  # Search path for Forms applications (.fmx files, PL/SQL libraries)
  # If you need to include more than one directory, they should be semi-colon
  # separated (e.g. c:\test\dir1;c:\test\dir2)
  #
  FORMS_PATH=D:\DevSuiteHome_1\forms;D:\DevSuiteHome_1\forms\webutil;D:\Sys\Forms;D:\Sys\General

  # webutil config file path
  WEBUTIL_CONFIG=D:\DevSuiteHome_1\forms\server\webutil.cfg

  # Disable/remove this variable if end-users need access to the query-where
  # functionality which potentially allows them to enter arbitrary SQL 
  # statements when in enter-query mode.
  FORMS_RESTRICT_ENTER_QUERY=TRUE

  #
  # The PATH setting is required in order to pick up the JVM (jvm.dll). 
  # The Forms runtime executable and dll's are assumed to be in 
  # D:\DevSuiteHome_1\bin if they are not in the PATH.
  # In addition, if you are running Graphics applications, you will need
  # to append the following to the path (where <Graphics Oracle Home> should
  # be replaced with the actual location of your Graphics 6i oracle_home):
  #
  # ;<Graphics Oracle Home>\bin;<Graphics Oracle Home>\jdk\bin
  # 

  PATH=D:\DevSuiteHome_1\jdk\bin;D:\DevSuiteHome_1\jdk\jre\bin\classic;D:\DevSuiteHome_1\jdk\jre\bin;D:\DevSuiteHome_1\jlib;D:\DevSuiteHome_1\jre\1.4.2\bin\client;D:\DevSuiteHome_1\jre\1.4.2\bin;D:\DevSuiteHome_1\jdk\jre\bin\client
  #
  # Settings for Graphics
  # -------------------------------
  # NOTE: These settings are only needed if Graphics applications 
  # are called from Forms applications. In addition, you will need to
  # modify the PATH variable above as described above.
  #

    #
    # Please uncomment the following and put the correct 6i 
    # oracle_home value to use Graphics applications.
    #
    #ORACLE_GRAPHICS6I_HOME=<your Graphics 6i oracle_home here>

    #
    # Search path for Graphics applications
    #
    #GRAPHICS60_PATH=

  #
  # Settings for Forms tracing and logging
  # -----------------------------------------------
  # Note: This entry has to be uncommented to enable tracing and
  # logging.

    #FORMS_TRACE_PATH=<FORMS_ORACLE_HOME>\forms\server
  

  #
  # System settings
  # ---------------
  # You should not normally need to modify these settings
  #
  FORMS=D:\DevSuiteHome_1\forms

  #
  # Java class path 
  #   This is required for the Forms debugger
  #   You can append your own Java code here)
  # frmsrv.jar, repository.jar and ldapjclnt10.jar are required for
  # the password expiry feature to work(#2213140).
  #
  CLASSPATH=D:\DevSuiteHome_1\j2ee\OC4J_BI_Forms\applications\formsapp\formsweb\WEB-INF\lib\frmsrv.jar;D:\DevSuiteHome_1\jlib\repository.jar;D:\DevSuiteHome_1\jlib\ldapjclnt10.jar;D:\DevSuiteHome_1\jlib\debugger.jar;D:\DevSuiteHome_1\jlib\ewt3.jar;D:\DevSuiteHome_1\jlib\share.jar;D:\DevSuiteHome_1\jlib\utj.jar;D:\DevSuiteHome_1\jlib\zrclient.jar;D:\DevSuiteHome_1\reports\jlib\rwrun.jar;D:\DevSuiteHome_1\forms\java\frmwebutil.jar;D:\DevSuiteHome_1\forms\java\icons.jar;D:\DevSuiteHome_1\jlib\zrclient.jar;D:\DevSuiteHome_1\reports\jlib\rwrun.jar;D:\DevSuiteHome_1\forms\java\jacob.jar;D:\DevSuiteHome_1\forms\java\frmall.jar;D:\DevSuiteHome_1\jdk\jre\lib\rt.jar
#local=sale
FORMS_PATH=C:\WINDOWS\Fonts;D:\Sys\GENERAL;D:\Sys\forms;D:\Sys\GENERAL\icons
REPORTS_PATH=C:\WINDOWS\Fonts;D:\Sys\GENERAL;D:\Sys\Reports

FORMS_MMAP=TRUE

Declare
V_Rep_Id Report_Object;
V_Repjob Varchar2(100);
V_Job_Id Varchar2(100);
V_Rep_Status Varchar2(100); 
V_Reportsrvr Varchar2(50) := 'rep_server';
V_Runformat Varchar2(50) := 'pdf';
Begin 
V_Rep_Id := Find_Report_Object('EMPSTATUS');
Set_Report_Object_Property(V_Rep_Id, Report_Comm_Mode, Synchronous);
Set_Report_Object_Property(V_Rep_Id, Report_Destype, Cache);

Set_Report_Object_Property(V_Rep_Id, Report_Server, V_Reportsrvr);
Set_Report_Object_Property(V_Rep_Id, Report_Desformat, V_Runformat); 

--Set_Report_Object_Property(V_Rep_Id, Report_Other, 'paramform=no');
Set_Report_Object_Property(V_Rep_Id, Report_Other, 'User_Id=' || :Global.User ||' paramform=no'); 

Set_Report_Object_Property(V_Rep_Id, Report_Filename, 'EMPSTATUS.rdf');

V_Repjob := Run_Report_Object(V_Rep_Id);
V_Job_Id := Substr(V_Repjob, Length(V_Reportsrvr) + 2, Length(V_Repjob) );
V_Rep_Status := Report_Object_Status(V_Repjob);

If V_Rep_Status = 'FINISHED' Then
Web.Show_Document('/reports/rwservlet/getjobid' || V_Job_Id ||'?server=' || V_Reportsrvr || '', '_blank');
Else
Message('Report failed with error message ');
End If;
End;