Home » Developer & Programmer » Reports & Discoverer » dynamic values (Reports 6i)
dynamic values [message #606322] Wed, 22 January 2014 05:49 Go to next message
m.abdulhaq
Messages: 125
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
cookiemonster
Messages: 10989
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: Thu Oct 02 01:49:44 CDT 2014

Total time taken to generate the page: 0.21034 seconds