Vidya Bala's Blog

Search My Blog

Add RSS Feed

Thursday, November 09, 2006

Dynamic Switching on a single 10g Reports Server instance (Part2)


If you have configured your Reports Server for Dynamic Switching with the ENVID parameter, the next step would be to set the ENVID for the Report Object before running the Report Object.

This can be down as below:
Set_Report_Object_Property(Rep_Id,REPORT_OTHER,'ENVID="test"');

However, the ENVID is not something that we want hardcoded in our forms and must be read from the Application Specific Forms env file.

For more details on the env file :
Cd $ORACLE_HOME/forms90/server/fromsweb.cfg
And envFile to Application specific configuration
# Remittance (RMS) Testing Section
[test]
workingDirectory=/app/oracle/test
form=TEST.fmx
pageTitle=TEST
envFile=test.env

cd $ORACLE_HOME/forms90/server/
cp default.env test.env
edit test.env to include your environmanet variables
eg REPORTS_ENVID=test
now this variable can be read from your form using the TOOL_ENV.GET_VAR function.

The env file can also include application specific authentication information if required.
At this point you have configured your 10g Reports and Forms Server for Multiple Applications.

1 Comments:

  • Vidya,
    Nice post , you could put a search box so I can do quick search in your posts for my stuff :) (Its just a suggestion)

    By Blogger Atul Kumar, at 9:07 AM  

Post a Comment

<< Home