Home » Developer & Programmer » Forms » Forms 10G
Forms 10G [message #273414] Wed, 10 October 2007 06:41 Go to next message
tenny
Messages: 3
Registered: October 2007
Junior Member
Hi,

I have migrated to forms 10g recently from forms 6i, i got some queries related to calling Multiple reports based on option selected.
Say if User select option A1 then report must be Rep1, IF B1 then report must be Rep2 and so on, My question is do i need to create/Add all Rep1,Rep2 ... under report node of Forms or i can just Add one report say rep1 and call them using Report_filename at runtime based on option. If this is possible can anyone give me some clues

thank in advance
Tenny

Report message to a moderator

Re: Forms 10G [message #273605 is a reply to message #273414] Thu, 11 October 2007 01:22 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I don't think that you need to have any reports defined against a form. Just call the reports by name.

I suggest most strongly that you use the 'web.show_document' method of report invocation.

David

Report message to a moderator

Re: Forms 10G [message #273649 is a reply to message #273605] Thu, 11 October 2007 03:26 Go to previous messageGo to next message
tenny
Messages: 3
Registered: October 2007
Junior Member

Thanks David for your prompt reply

In my case i am using run_report_object to process the report as i am passing parameter list to
report and then using web.show_document to open in new window

I have a common parameter form, based on user choice different report are being called, as i form
the entire sql query in form based on parameter values and pass it to report which uses lexical parameter,
so i have almost 60 differnt reports being called from this form,but only one is called at a time
Any tips on how to go about this

thank you in advance

Report message to a moderator

Re: Forms 10G [message #273858 is a reply to message #273649] Fri, 12 October 2007 00:51 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Again, drop the use of 'run_report_object'. Search this forum 'web.show_document'.

Concerning "Any tips on how to go about this" I can not perceive there being any problem. You can build the name of the report dynamically and as long as the report exists it will run.

David

Report message to a moderator

Re: Forms 10G [message #274282 is a reply to message #273858] Mon, 15 October 2007 06:12 Go to previous messageGo to next message
tenny
Messages: 3
Registered: October 2007
Junior Member

Hi David,

i just tried the below mention code to call report from forms using web.show_document

declare
P_REP_URL VARCHAR2(4000);
BEGIN
p_rep_url:= '/reports/rwservlet?server=rep_fsprod&report=reptst.rdf&desformat=PDF&destype=cache'||
'&userid=scott23/lion@acl&paramform=no' ;

WEB.SHOW_DOCUMENT(p_rep_url,'_blank');
END;

i have already set reports_path and rep_fsprod server is also runing, but still following errors are raised

REP-110: Unable to open file 'reptst.rdf'.
REP-1070: Error while opening or saving a document.
REP-0110: Unable to open file 'reptst.rdf'.

Am i missing something in my code?

Report message to a moderator

Re: Forms 10G [message #274371 is a reply to message #274282] Mon, 15 October 2007 20:47 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Search this forum '/reports/rwservlet?server' and see other posters' solutions.

David

[Updated on: Mon, 15 October 2007 20:48]

Report message to a moderator

Previous Topic: how can i send print command from form to printer?
Next Topic: calendar window in 10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 18:58:43 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.