Home » Developer & Programmer » Reports & Discoverer » Passing parameters to reports from forms. (Oracle Developer suite 10g, OS-Vista)
Passing parameters to reports from forms. [message #405454] Wed, 27 May 2009 22:15
Messages: 3
Registered: April 2009
Junior Member
we are using developer suite 10g and developed some applications.Our reports are working from report buider and also from the forms when we are not passing any parameter.
But when we add the clause to pass the parameter from forms fields it does not show any values and we get a blank report.

when we use this code it works with default value set in the report

But when we use code to pass the parameter like this it does not work
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'EMPLOYEE_TICKET_NO='||lpad(ltrim(:hris_employee.em_ticket_no),5,' ')||'paramform=no');

Please suggest how to pass parameter values from forms.
Thanks in advance
Previous Topic: Inventory Valuation with Fifo and Lifo
Next Topic: Export data from RDF to Excel
Goto Forum:

Current Time: Mon Aug 21 22:37:43 CDT 2017

Total time taken to generate the page: 0.10002 seconds