report parameter & url error (merged) [message #143713] |
Fri, 21 October 2005 10:44 |
maoro
Messages: 312 Registered: May 2005
|
Senior Member |
|
|
hello
i apprecaite your kind help over that
i want to run a report that select the data from the base tables filtered through a CRITERIA PASSED TO THE REPORT FROM THE FORM
I CREATED THE TEXT ITEM IN THE FORM BUT WHEN I CALL THE REPORT
I GET AN ERROR THAT THE REPORT NAME IS MISSING
EVEN THAT I REGISTERED THE REPORT IN THE FORM NAVIGATOR
I USED RUN_REPORT_OBJECT
WEB.SHOW_DOCUMENT IT NEVER WORKS
PLEASE A SMALL DEMO
AND THX FOR DJMARTIN YOU HELPED SO MUCH !!!
|
|
|
|
Re: report parameter [message #143914 is a reply to message #143713] |
Mon, 24 October 2005 02:57 |
maoro
Messages: 312 Registered: May 2005
|
Senior Member |
|
|
hello
forms and reports were working just fine
now when i try to run a form from forms9i for example
i got wondows explorer opening but with something like
'%http://%forms%'http:127.0.0.1:888........'
so i have to remove every time that part
'%http://%forms% from the begininh of the url in order to work
and reports use to work
now when i run any internet explorer opens and u wait forever for nothing
thx
|
|
|
|
|
|
Re: url error [message #144117 is a reply to message #144066] |
Tue, 25 October 2005 02:31 |
maoro
Messages: 312 Registered: May 2005
|
Senior Member |
|
|
actually nothing david
well i noticed that i had some issues runing pdf fprmat report
guess what because i new version of acribat that i installed
so reports run fine in html format
and i have this problem when i run the form from form developper
only cause u know i created links with the %http:%.... in the begining
is there configuration files that maybe solve it
thanks
|
|
|
|
Re: url error [message #144441 is a reply to message #144013] |
Wed, 26 October 2005 08:02 |
adamjsawyer
Messages: 79 Registered: April 2005 Location: Perth, Western Australia ...
|
Member |
|
|
the %20 means there is a space in there somewhere if I remember rightly. There can't be any spaces. You may need to set the URL somehow. I know that sometimes my Form Builder forgets the server url and does something very similar to what you have described. I just go into options and fix the URL. It needs to be set according to what David has been telling you.
Sorry I can't help more
adam
|
|
|
|
Re: url error [message #144527 is a reply to message #144504] |
Wed, 26 October 2005 21:41 |
adamjsawyer
Messages: 79 Registered: April 2005 Location: Perth, Western Australia ...
|
Member |
|
|
Thanks David,
The only thing left I need to work out is how to make FIND_REPORT actually find the report. I am not allowed to change any registry settings (my lecturer doesn't like it), so I was hoping to place my .RDF files in a directory that will definitely be looked in by Oracle on any system. Is there somewhere under the developer oracle home that i can put them, and just use FIND_REPORT to get them? I have already discovered i can generate the html files into the forms90/tools/web90/html, and just reference them by "http://127.0.0.1:8888/forms90/html/report.html" - i do this because the file:/// doesn't work for SHOW_DOCUMENT on XP SP2, but http:// does.
Perhaps I can change an oracle environment variable instead? if so, which one and how?
cheers
adam
|
|
|
|
|
Re: report parameter & url error (merged) [message #144793 is a reply to message #144772] |
Fri, 28 October 2005 06:25 |
adamjsawyer
Messages: 79 Registered: April 2005 Location: Perth, Western Australia ...
|
Member |
|
|
To fix your forms URL, I suggest you go into Edit->Preferences->Runtime, and check the options there. There is one for the forms URL (I think it's called App server URL or some such), and one for your browser path. If the forms URL is missing, it could explain why the correct path is not coming up.
I set mine to:
http://127.0.0.1:8888/forms90/f90servlet
Yours may need to be different
Hope it helps,
Adam
|
|
|
|
|
|