Home » Developer & Programmer » Forms » report parameter & url error (merged)
report parameter & url error (merged) [message #143713] Fri, 21 October 2005 10:44 Go to next message
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 #143888 is a reply to message #143713] Sun, 23 October 2005 23:54 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Search this forum for 'run_report_object' and 'web.show_document'. You probably need to define the REPORTS_PATH in your Register.

David
Re: report parameter [message #143914 is a reply to message #143713] Mon, 24 October 2005 02:57 Go to previous messageGo to next message
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
url error [message #144013 is a reply to message #143713] Mon, 24 October 2005 11:24 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
hi
when i made a from using forms9i and i run the form from the forms developer i got this url in internet explorer

http://%%20" http://maoro:8888/forms90/f90servlet?form=C:\forms\LOCCALREPORT.fmx&userid=HR/HR@ORCL&buffer_records=NO&debug_messages=NO &array=YES&query_only=NO&quiet=NO&RENDER=YES"

so i have to manually remove the first part " http://%%" in order for the form to run

help is appreciated
thanks
Re: report parameter [message #144055 is a reply to message #143914] Mon, 24 October 2005 18:00 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Next time please show us the code that is producing this error. Most of the participants of this forum are not psychic.

I believe that your 'web.show_document' call has the form 'http:127.0.0.1:8888/reports/rwservlet?'.

YOU don't need to have the 'http:127.0.0.1:8888' in your call. Just have '/reports/rwservlet?'.

David
Re: url error [message #144066 is a reply to message #144013] Mon, 24 October 2005 21:27 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Your forms were working. What did you change?

David
Re: url error [message #144117 is a reply to message #144066] Tue, 25 October 2005 02:31 Go to previous messageGo to next message
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 #144299 is a reply to message #144117] Tue, 25 October 2005 17:57 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Please post your code.

David
Re: url error [message #144441 is a reply to message #144013] Wed, 26 October 2005 08:02 Go to previous messageGo to next message
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 #144504 is a reply to message #144441] Wed, 26 October 2005 18:46 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Thanks Adam ... it wasn't the 20% 'code' I was after but the actual PL/SQL code in the trigger.

The following is all the code you need to run and display your report. You will have to write or substitute your own function for the 'f_report_server'.

DECLARE
   vrepid                        report_object;
   vrep                           VARCHAR2 (100);
   -- 09/08/2004 DJMartin Add WEB style report.
   v_show_document       VARCHAR2 (2000) := '/reports/rwservlet?';
   v_connect                  VARCHAR2 (30)   := 'connectionName';
   v_report_server         VARCHAR2 (30)   := reportsenv_pkg.f_report_server;
BEGIN
   IF GET_APPLICATION_PROPERTY (user_interface) = 'WEB'
   THEN
      v_show_document := v_show_document
         || v_connect
         -- Report server
         || '&server='
         || v_report_server
         -- Report name
         || '&report=gnrAgenda'
         -- Reports parameters
         || '&destype=CACHE'
         || '&desformat=PDF';
      web.show_document (v_show_document);
   ELSE
      vrepid := FIND_REPORT_OBJECT ('REPORT1');
      vrep := RUN_REPORT_OBJECT (vrepid);
      web.show_document
                (   'http://address:port/reports/rwservlet/getjobid'
                 || SUBSTR (vrep, INSTR (vrep, '_', -1) + 1)
                 || '?'
                 || 'server=repserver90',
                 '_blank'
                );
   END IF;
END;


David
Re: url error [message #144527 is a reply to message #144504] Wed, 26 October 2005 21:41 Go to previous messageGo to next message
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: url error [message #144529 is a reply to message #144527] Wed, 26 October 2005 21:57 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Are you running these reports on each PC or via an Application Server?

Each PC running as a DS SHOULD have REPORTS_PATH defined. Store your 'rdf' or 'rep' in there.

If you are using an AS then IT will have a REPORTS_PATH defined in the reports config.

As my code shows, you don't need to use FIND_REPORT when running with user_interface = 'WEB'.

David
Re: report parameter & url error (merged) [message #144772 is a reply to message #143713] Fri, 28 October 2005 03:33 Go to previous messageGo to next message
maoro
Messages: 312
Registered: May 2005
Senior Member
hi
i still have the same prob with all my forms
when i made a form using forms9i and i run the form from the forms developer i got this url in internet explorer

http://%%20" http://maoro:8888/forms90/f90servlet?form=C:\forms\LOCCALREPORT.fmx&userid=HR/HR@ORCL&buffer_records=NO&debug_messages=NO &array=YES&query_only=NO&quiet=NO&RENDER=YES"

so i have to manually remove the first part " http://%%" in order for the form to run

plus when i run the report from the form i wanted to run maximized
so the solution works fimr for the form which i run the report
so how can i maximize the report being called

ill attach a samplefile that has both issues

help is appreciated
thanks
Re: report parameter & url error (merged) [message #144793 is a reply to message #144772] Fri, 28 October 2005 06:25 Go to previous messageGo to next message
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
Re: report parameter & url error (merged) [message #144989 is a reply to message #144772] Sun, 30 October 2005 21:35 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Which part of:
Quote:

YOU don't need to have the 'http:127.0.0.1:8888' in your call. Just have '/reports/rwservlet?'.
don't you understand?

Look at the sample code in my previous post.

You forms contains:
Rep_url:='http://127.0.0.1:8888/reports/rwservlet?destype=cache&desformat=HTMLCSS&report=emp.rdf&userid=hr/hr@orcl&paramform=no';

Change your code to remove the *^%$ing "'http://127.0.0.1:8888" and it will work.

David
Re: report parameter & url error (merged) [message #145022 is a reply to message #144989] Mon, 31 October 2005 06:21 Go to previous messageGo to next message
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
Member
ah i see the point. I've done mine the same way now.

cheers
Adam
Re: report parameter & url error (merged) [message #145082 is a reply to message #145022] Mon, 31 October 2005 15:43 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Adam,

Sorry about getting so uptight yesterday but I needed to get your attention. I am VERY glad that it is now working for you.

David
Previous Topic: logon
Next Topic: Error 500--Internal Server Error
Goto Forum:
  


Current Time: Fri Sep 20 01:50:51 CDT 2024