Home » Developer & Programmer » Reports & Discoverer » dynamic values (Reports 6i)
dynamic values [message #606322] Wed, 22 January 2014 05:49 Go to next message
Messages: 253
Registered: April 2013
Location: Ajman
Senior Member
I am passing values of forms like 'DR','PN' To a variable in Reports 6i, inside Query of main sql in report data model as where clause, i am using like

select * from
products where dept_id in (:p_dept);

the 'DR' , 'PN' are passed from forms to :p_dept variable.How can i use it inside query to display results dynamically.

the result is not getting displayed , but i checked the values passed from form into label , they are getting displayed, how can i pass such values into a report data model.

Re: dynamic values [message #606324 is a reply to message #606322] Wed, 22 January 2014 06:12 Go to previous message
Messages: 13904
Registered: September 2008
Location: Rainy Manchester
Senior Member
varying in list
Previous Topic: Broken Images are displayed in discoverer 11g
Next Topic: How to implement Bar code in Oracle Apps Report
Goto Forum:

Current Time: Fri Dec 09 22:31:50 CST 2022