Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

No Paramform? 1

Status
Not open for further replies.

studi2312

Programmer
Jul 2, 2003
4
DE
Hi guys

Iam a programmer of oracle reports6i.
I tried to put my reports on a webserver/reportserver together with some forms files.

Running these reports through the forms files (.fmx) is no problem BUT there is NO parameter form.
And i really need this.

I tried to solve the problem with putting the paramform parameter in a parameter list

like : Add_Parameter(the_list, 'PARAMFORM',TEXT_PARAMETER,'YES'); BUT nothing happend, all other parameters are recognize !!

Please help me

May god bless all programmer. *laugh*
 
First of all you should launch report by RUN_REPORT_OBJECT. Then you may add parameters as key-value pairs by seting REPORT_OTHER property. Note, that you can not pass DATA parameters on the web.

Regards, Dima
 
I do run it like that, using this built-in.

Add_Parameter(the_list, 'PARAMFORM',TEXT_PARAMETER,'YES'); is only for filling the parameter list.

 
Read it again: not filling the list by Add_Parameter, but setting REPORT_OTHER property:

set_report_object_property(<your_report>, REPORT_OTHER, 'param1=value1 param2=value2')

The value PARAMFORM is ignored on the web, so you should create your own parameter form (in FORMS), accept parameters and then pass them to report server.

Regards, Dima
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top