| calling report from forms where report is in another folder [message #269263] |
Fri, 21 September 2007 07:15  |
ShaShalini
Messages: 59
Registered: January 2007
|
Member |
|
|
Hi All
I am calling reports from a forms. All my form executables are in a particular folder and report in another folder.
e.g /d01/project/forms -- where forms are saved
/d01/project/reports -- where reports are saved.
When I am calling the reports I don't want to hardcode the path in the forms.
Any idea where I can set this path so that if tomorrow the report path changes in the server , I don't have to open all the forms and change the path ..
Hope am clear with my question
Thanks
|
|
|
|
|
|
|
|
|
|
| Re: calling report from forms where report is in another folder [message #269703 is a reply to message #269651] |
Mon, 24 September 2007 03:21  |
ShaShalini
Messages: 59
Registered: January 2007
|
Member |
|
|
This Environment variable will solve the problem only if all the reports are in the same folder.
I have 2 projects .. and for each project I have got a different instances.
Now for project 1 the reports will be saved in
e.g /d01/prj1/reports
and for project 2 the reports wil be saved in /d01/prj2/reports.
And I don't want to keep the folder name in a field in some table .. This will be the last option ..
Thanks
|
|
|
|
| Re: calling report from forms where report is in another folder [message #270001 is a reply to message #269703] |
Tue, 25 September 2007 06:33 |
Form-Al-Dehide
Messages: 2
Registered: September 2007
Location: Adelaide Australia
|
Junior Member |
|
|
Hi there,
I don't understand why you cannot modify the environment file (default.env or <module name>.env) and stipulate the Reports Path in there.
We had a tricky situation where reports that were common to multiple applications were stored in two locations and nowhere near the Form executables.
What we crafted the REPORTS_PATH in the environment file to start searching for a Report in the application-specific folder first, and if it did not find it there then it then searched a whole series of other folders for the Report.
Works like a dream and has never failed.
So, the sequence is:-
1) Check your formsweb.cfg again
2) Check your environment file (default.env) and add it in there
3) Modify your registry setting for REPORTS_PATH, (or environment file on Unix. etc.)
4) Hard-code it in to the Form (last resort and bad practice)
Hope you can get some value out of this...
Al
|
|
|
|
|
|
|
|
| Re: calling report from forms where report is in another folder [message #270450 is a reply to message #270341] |
Wed, 26 September 2007 22:39 |
Form-Al-Dehide
Messages: 2
Registered: September 2007
Location: Adelaide Australia
|
Junior Member |
|
|
Hi,
One other thing to check is that the full path to the report file has been removed in the Report Object properties in Object Navigator.
It should just show the report object name (e.g. reportname.rdf) and not show the full path. This needs to be done for all reports.
On a side note, if you are migrating from say, Forms 5 to 10g, you need to create the Report Objects for each report and this is when the full path can unwittingly sneak its way in and mess things up.
Also, if I remember rghtly, if the full path is in the Properties it will override any other setting.
Al
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
